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_ENTRY_VALUES_F

Line 1964: pay_element_entry_values_f peevf

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
1968: AND peef.element_type_id = g_ni_pt_eid

Line 2134: pay_element_entry_values_f peevf ,

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
2138: and peef.ELEMENT_TYPE_ID = g_adv_period_id

Line 2750: pay_element_entry_values_f peevf

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
2754: AND peef.element_type_id = g_ni_pt_eid

Line 2910: pay_element_entry_values_f peevf ,

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
2914: and peef.ELEMENT_TYPE_ID = g_adv_period_id

Line 3552: pay_element_entry_values_f peevf

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
3556: AND peef.element_type_id = g_ni_pt_eid

Line 3713: pay_element_entry_values_f peevf ,

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
3717: and peef.ELEMENT_TYPE_ID = g_adv_period_id

Line 4562: pay_element_entry_values_f v,

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
4566: AND link.element_type_id = g_paye_details_id

Line 4835: pay_element_entry_values_f v,

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
4839: AND link.element_type_id = g_paye_details_id

Line 5103: pay_element_entry_values_f v,

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
5107: AND link.element_type_id = g_paye_details_id

Line 5785: pay_element_entry_values_f v,

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
5789: AND link.element_type_id = g_paye_details_id