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 dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1454: pay_element_entry_values_f peevf

1450: IS
1451: SELECT peevf.screen_entry_value screen_value
1452: FROM
1453: pay_element_entries_f peef,
1454: pay_element_entry_values_f peevf
1455: WHERE peef.assignment_id = c_asg_id
1456: AND peef.element_entry_id = peevf.element_entry_id
1457: AND peevf.input_value_id = g_ni_pt_ivid
1458: AND peef.element_type_id = g_ni_pt_eid

Line 1629: pay_element_entry_values_f peevf ,

1625: is
1626: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
1627: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
1628: from pay_element_entries_f peef,
1629: pay_element_entry_values_f peevf ,
1630: pay_input_values_f pivf
1631: where
1632: peef.assignment_id = p_person_rec.assignment_id
1633: and peef.ELEMENT_TYPE_ID = g_adv_period_id

Line 2272: pay_element_entry_values_f peevf

2268: IS
2269: SELECT peevf.screen_entry_value screen_value
2270: FROM
2271: pay_element_entries_f peef,
2272: pay_element_entry_values_f peevf
2273: WHERE peef.assignment_id = c_asg_id
2274: AND peef.element_entry_id = peevf.element_entry_id
2275: AND peevf.input_value_id = g_ni_pt_ivid
2276: AND peef.element_type_id = g_ni_pt_eid

Line 2437: pay_element_entry_values_f peevf ,

2433: is
2434: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
2435: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
2436: from pay_element_entries_f peef,
2437: pay_element_entry_values_f peevf ,
2438: pay_input_values_f pivf
2439: where
2440: peef.assignment_id = p_person_rec.assignment_id
2441: and peef.ELEMENT_TYPE_ID = g_adv_period_id

Line 3085: pay_element_entry_values_f peevf

3081: IS
3082: SELECT peevf.screen_entry_value screen_value
3083: FROM
3084: pay_element_entries_f peef,
3085: pay_element_entry_values_f peevf
3086: WHERE peef.assignment_id = c_asg_id
3087: AND peef.element_entry_id = peevf.element_entry_id
3088: AND peevf.input_value_id = g_ni_pt_ivid
3089: AND peef.element_type_id = g_ni_pt_eid

Line 3251: pay_element_entry_values_f peevf ,

3247: is
3248: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
3249: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
3250: from pay_element_entries_f peef,
3251: pay_element_entry_values_f peevf ,
3252: pay_input_values_f pivf
3253: where
3254: peef.assignment_id = l_asg_id
3255: and peef.ELEMENT_TYPE_ID = g_adv_period_id

Line 3986: pay_element_entry_values_f v,

3982: cursor csr_tax_code_basis is
3983: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)),
3984: decode(max(decode(iv.name,'Tax Basis',screen_entry_value)),'N','Y',NULL)
3985: FROM pay_element_entries_f e,
3986: pay_element_entry_values_f v,
3987: pay_input_values_f iv,
3988: pay_element_links_f link
3989: WHERE e.assignment_id = p_asg_id
3990: AND link.element_type_id = g_paye_details_id

Line 4248: pay_element_entry_values_f v,

4244: cursor csr_tax_code_basis is
4245: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)),
4246: decode(max(decode(iv.name,'Tax Basis',screen_entry_value)),'N','Y',NULL)
4247: FROM pay_element_entries_f e,
4248: pay_element_entry_values_f v,
4249: pay_input_values_f iv,
4250: pay_element_links_f link
4251: WHERE e.assignment_id = p_asg_id
4252: AND link.element_type_id = g_paye_details_id

Line 4505: pay_element_entry_values_f v,

4501: CURSOR csr_paye_details(p_assignment_id NUMBER) IS
4502: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
4503: max(decode(iv.name,'Tax Basis',DECODE(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- kvinayku bug no 14774165
4504: FROM pay_element_entries_f e,
4505: pay_element_entry_values_f v,
4506: pay_input_values_f iv,
4507: pay_element_links_f link
4508: WHERE e.assignment_id = p_asg_id
4509: AND link.element_type_id = g_paye_details_id

Line 5171: pay_element_entry_values_f v,

5167: CURSOR csr_paye_details(p_assignment_id NUMBER) IS
5168: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
5169: max(decode(iv.name,'Tax Basis',decode(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- added by kvinayku 14774165
5170: FROM pay_element_entries_f e,
5171: pay_element_entry_values_f v,
5172: pay_input_values_f iv,
5173: pay_element_links_f link
5174: WHERE e.assignment_id = p_asg_id
5175: AND link.element_type_id = g_paye_details_id