eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 1963: pay_element_entries_f peef,

1959: CURSOR csr_ni_info(c_asg_id NUMBER, c_asg_eff_start_date DATE)
1960: IS
1961: SELECT peevf.screen_entry_value screen_value
1962: FROM
1963: pay_element_entries_f peef,
1964: pay_element_entry_values_f peevf
1965: WHERE peef.assignment_id = c_asg_id
1966: AND peef.element_entry_id = peevf.element_entry_id
1967: AND peevf.input_value_id = g_ni_pt_ivid

Line 2133: from pay_element_entries_f peef,

2129: cursor csr_advance_pay_dates
2130: is
2131: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
2132: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
2133: from pay_element_entries_f peef,
2134: pay_element_entry_values_f peevf ,
2135: pay_input_values_f pivf
2136: where
2137: peef.assignment_id = p_person_rec.assignment_id

Line 2749: pay_element_entries_f peef,

2745: CURSOR csr_ni_info(c_asg_id NUMBER, c_asg_eff_start_date DATE)
2746: IS
2747: SELECT peevf.screen_entry_value screen_value
2748: FROM
2749: pay_element_entries_f peef,
2750: pay_element_entry_values_f peevf
2751: WHERE peef.assignment_id = c_asg_id
2752: AND peef.element_entry_id = peevf.element_entry_id
2753: AND peevf.input_value_id = g_ni_pt_ivid

Line 2909: from pay_element_entries_f peef,

2905: cursor csr_advance_pay_dates
2906: is
2907: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
2908: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
2909: from pay_element_entries_f peef,
2910: pay_element_entry_values_f peevf ,
2911: pay_input_values_f pivf
2912: where
2913: peef.assignment_id = p_person_rec.assignment_id

Line 3551: pay_element_entries_f peef,

3547: CURSOR csr_ni_info(c_asg_id NUMBER, c_asg_eff_start_date DATE)
3548: IS
3549: SELECT peevf.screen_entry_value screen_value
3550: FROM
3551: pay_element_entries_f peef,
3552: pay_element_entry_values_f peevf
3553: WHERE peef.assignment_id = c_asg_id
3554: AND peef.element_entry_id = peevf.element_entry_id
3555: AND peevf.input_value_id = g_ni_pt_ivid

Line 3712: from pay_element_entries_f peef,

3708: cursor csr_advance_pay_dates
3709: is
3710: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
3711: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
3712: from pay_element_entries_f peef,
3713: pay_element_entry_values_f peevf ,
3714: pay_input_values_f pivf
3715: where
3716: peef.assignment_id = l_asg_id

Line 4561: FROM pay_element_entries_f e,

4557:
4558: cursor csr_tax_code_basis is
4559: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)),
4560: decode(max(decode(iv.name,'Tax Basis',screen_entry_value)),'N','Y',NULL)
4561: FROM pay_element_entries_f e,
4562: pay_element_entry_values_f v,
4563: pay_input_values_f iv,
4564: pay_element_links_f link
4565: WHERE e.assignment_id = p_asg_id

Line 4574: from pay_element_entries_f e1,

4570: AND e.effective_end_date BETWEEN link.effective_start_date AND link.effective_end_date
4571: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
4572: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
4573: AND e.effective_end_date = (select max(e1.effective_end_date)
4574: from pay_element_entries_f e1,
4575: pay_element_links_f link1
4576: where link1.element_type_id = g_paye_details_id
4577: and e1.assignment_id = p_asg_id
4578: and e1.element_link_id = link1.element_link_id);

Line 4834: FROM pay_element_entries_f e,

4830:
4831: cursor csr_tax_code_basis is
4832: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)),
4833: decode(max(decode(iv.name,'Tax Basis',screen_entry_value)),'N','Y',NULL)
4834: FROM pay_element_entries_f e,
4835: pay_element_entry_values_f v,
4836: pay_input_values_f iv,
4837: pay_element_links_f link
4838: WHERE e.assignment_id = p_asg_id

Line 4847: from pay_element_entries_f e1,

4843: AND e.effective_end_date BETWEEN link.effective_start_date AND link.effective_end_date
4844: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
4845: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
4846: AND e.effective_end_date = (select max(e1.effective_end_date)
4847: from pay_element_entries_f e1,
4848: pay_element_links_f link1
4849: where link1.element_type_id = g_paye_details_id
4850: and e1.assignment_id = p_asg_id
4851: and e1.element_link_id = link1.element_link_id);

Line 5102: FROM pay_element_entries_f e,

5098:
5099: CURSOR csr_paye_details(p_assignment_id NUMBER) IS
5100: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
5101: max(decode(iv.name,'Tax Basis',DECODE(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- kvinayku bug no 14774165
5102: FROM pay_element_entries_f e,
5103: pay_element_entry_values_f v,
5104: pay_input_values_f iv,
5105: pay_element_links_f link
5106: WHERE e.assignment_id = p_asg_id

Line 5115: from pay_element_entries_f e1,

5111: AND e.effective_end_date BETWEEN link.effective_start_date AND link.effective_end_date
5112: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
5113: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
5114: AND e.effective_end_date = (select max(e1.effective_end_date)
5115: from pay_element_entries_f e1,
5116: pay_element_links_f link1
5117: where link1.element_type_id = g_paye_details_id
5118: and e1.assignment_id = p_asg_id
5119: and e1.element_link_id = link1.element_link_id);

Line 5784: FROM pay_element_entries_f e,

5780:
5781: CURSOR csr_paye_details(p_assignment_id NUMBER) IS
5782: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
5783: max(decode(iv.name,'Tax Basis',decode(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- added by kvinayku 14774165
5784: FROM pay_element_entries_f e,
5785: pay_element_entry_values_f v,
5786: pay_input_values_f iv,
5787: pay_element_links_f link
5788: WHERE e.assignment_id = p_asg_id

Line 5797: from pay_element_entries_f e1,

5793: AND e.effective_end_date BETWEEN link.effective_start_date AND link.effective_end_date
5794: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
5795: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
5796: AND e.effective_end_date = (select max(e1.effective_end_date)
5797: from pay_element_entries_f e1,
5798: pay_element_links_f link1
5799: where link1.element_type_id = g_paye_details_id
5800: and e1.assignment_id = p_asg_id
5801: and e1.element_link_id = link1.element_link_id);