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_ENTRIES_F

Line 1453: pay_element_entries_f peef,

1449: CURSOR csr_ni_info(c_asg_id NUMBER, c_asg_eff_start_date DATE)
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

Line 1628: from pay_element_entries_f peef,

1624: cursor csr_advance_pay_dates
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

Line 2271: pay_element_entries_f peef,

2267: CURSOR csr_ni_info(c_asg_id NUMBER, c_asg_eff_start_date DATE)
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

Line 2436: from pay_element_entries_f peef,

2432: cursor csr_advance_pay_dates
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

Line 3084: pay_element_entries_f peef,

3080: CURSOR csr_ni_info(c_asg_id NUMBER, c_asg_eff_start_date DATE)
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

Line 3250: from pay_element_entries_f peef,

3246: cursor csr_advance_pay_dates
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

Line 3985: FROM pay_element_entries_f e,

3981:
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

Line 3998: from pay_element_entries_f e1,

3994: AND e.effective_end_date BETWEEN link.effective_start_date AND link.effective_end_date
3995: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
3996: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
3997: AND e.effective_end_date = (select max(e1.effective_end_date)
3998: from pay_element_entries_f e1,
3999: pay_element_links_f link1
4000: where link1.element_type_id = g_paye_details_id
4001: and e1.assignment_id = p_asg_id
4002: and e1.element_link_id = link1.element_link_id);

Line 4247: FROM pay_element_entries_f e,

4243:
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

Line 4260: from pay_element_entries_f e1,

4256: AND e.effective_end_date BETWEEN link.effective_start_date AND link.effective_end_date
4257: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
4258: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
4259: AND e.effective_end_date = (select max(e1.effective_end_date)
4260: from pay_element_entries_f e1,
4261: pay_element_links_f link1
4262: where link1.element_type_id = g_paye_details_id
4263: and e1.assignment_id = p_asg_id
4264: and e1.element_link_id = link1.element_link_id);

Line 4504: FROM pay_element_entries_f e,

4500:
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

Line 4517: from pay_element_entries_f e1,

4513: AND e.effective_end_date BETWEEN link.effective_start_date AND link.effective_end_date
4514: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
4515: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
4516: AND e.effective_end_date = (select max(e1.effective_end_date)
4517: from pay_element_entries_f e1,
4518: pay_element_links_f link1
4519: where link1.element_type_id = g_paye_details_id
4520: and e1.assignment_id = p_asg_id
4521: and e1.element_link_id = link1.element_link_id);

Line 5170: FROM pay_element_entries_f e,

5166:
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

Line 5183: from pay_element_entries_f e1,

5179: AND e.effective_end_date BETWEEN link.effective_start_date AND link.effective_end_date
5180: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
5181: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
5182: AND e.effective_end_date = (select max(e1.effective_end_date)
5183: from pay_element_entries_f e1,
5184: pay_element_links_f link1
5185: where link1.element_type_id = g_paye_details_id
5186: and e1.assignment_id = p_asg_id
5187: and e1.element_link_id = link1.element_link_id);