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_NL_WAGE_REPORT_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 7435: ,pay_element_entries_f pee1

7431: FROM pay_run_results rr1 -- Retro element
7432: ,pay_element_span_usages esu
7433: ,pay_retro_component_usages rcu
7434: ,pay_retro_components rc
7435: ,pay_element_entries_f pee1
7436: ,pay_assignment_actions paa1
7437: ,pay_payroll_actions ppa1
7438: ,per_time_periods ptp
7439: WHERE paa1.source_action_id = paa.assignment_action_id

Line 9346: FROM pay_element_entries_f peef

9342: ,p_detail_tab IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type) IS
9343: CURSOR csr_get_element_entries(c_assignment_id NUMBER
9344: ,c_eff_date DATE) IS
9345: SELECT peef.element_entry_id
9346: FROM pay_element_entries_f peef
9347: ,pay_element_types_f pet
9348: WHERE pet.element_name IN ('Holiday Coupons','Incidental Income Decrease','Additional Allowance','Company Car Private Usage')
9349: AND pet.legislation_code = 'NL'
9350: AND peef.assignment_id = c_assignment_id

Line 9383: OPEN csr_get_table_id('PAY_ELEMENT_ENTRIES_F');

9379: l_table3 pay_dated_tables.dated_table_id%type;
9380: --
9381: BEGIN
9382: --
9383: OPEN csr_get_table_id('PAY_ELEMENT_ENTRIES_F');
9384: FETCH csr_get_table_id INTO l_table1;
9385: CLOSE csr_get_table_id;
9386: --
9387: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');

Line 9395: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRIES_F : '||l_table1);

9391: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');
9392: FETCH csr_get_table_id INTO l_table3;
9393: CLOSE csr_get_table_id;
9394: --
9395: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRIES_F : '||l_table1);
9396: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRY_VALUES_F : '||l_table1);
9397: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PER_ASSIGNMENT_EXTRA_INFO : '||l_table1);
9398: l_cnt := 1;
9399: FOR c_rec IN csr_get_element_entries(p_assignment_id,p_end_date) LOOP

Line 9710: ,pay_element_entries_f pee

9706: ,c_date DATE) IS
9707: SELECT DISTINCT ptp.start_date start_date
9708: ,ptp.end_date end_date
9709: FROM pay_run_results prr
9710: ,pay_element_entries_f pee
9711: ,pay_assignment_actions paa
9712: ,pay_payroll_actions ppa
9713: ,per_time_periods ptp
9714: WHERE prr.assignment_action_id = paa.assignment_action_id

Line 9735: ,pay_element_entries_f pee1

9731: ,pay_run_results rr2 -- Normal Element
9732: ,pay_element_span_usages esu
9733: ,pay_retro_component_usages rcu
9734: ,pay_retro_components rc
9735: ,pay_element_entries_f pee1
9736: ,pay_element_entries_f pee2
9737: ,pay_retro_assignments pra
9738: ,pay_retro_entries pre
9739: WHERE rr1.assignment_action_id = c_assignment_action_id

Line 9736: ,pay_element_entries_f pee2

9732: ,pay_element_span_usages esu
9733: ,pay_retro_component_usages rcu
9734: ,pay_retro_components rc
9735: ,pay_element_entries_f pee1
9736: ,pay_element_entries_f pee2
9737: ,pay_retro_assignments pra
9738: ,pay_retro_entries pre
9739: WHERE rr1.assignment_action_id = c_assignment_action_id
9740: AND rr2.assignment_action_id = rr1.assignment_action_id

Line 9767: ,pay_element_entries_f pee1

9763: FROM pay_run_results rr1 -- Retro element
9764: ,pay_element_span_usages esu
9765: ,pay_retro_component_usages rcu
9766: ,pay_retro_components rc
9767: ,pay_element_entries_f pee1
9768: ,pay_assignment_actions paa
9769: ,pay_payroll_actions ppa
9770: ,per_time_periods ptp
9771: WHERE paa.assignment_action_id = c_assignment_action_id

Line 9851: WHERE TABLE_NAME = c_table_name; -- in ('PAY_ELEMENT_ENTRY_VALUES_F','PAY_ELEMENT_ENTRIES_F');

9847: --
9848: CURSOR csr_get_table_id(c_table_name VARCHAR2) IS
9849: SELECT dated_table_id
9850: FROM pay_dated_tables
9851: WHERE TABLE_NAME = c_table_name; -- in ('PAY_ELEMENT_ENTRY_VALUES_F','PAY_ELEMENT_ENTRIES_F');
9852: --
9853: CURSOR csr_get_element_det(c_element_name VARCHAR2
9854: ,c_input_val_name VARCHAR2
9855: ,c_assignment_id NUMBER

Line 9860: ,pay_element_entries_f peef

9856: ,c_eff_date DATE) IS
9857: SELECT peev.screen_entry_value
9858: FROM pay_element_types_f pet
9859: ,pay_input_values_f piv
9860: ,pay_element_entries_f peef
9861: ,pay_element_entry_values_f peev
9862: WHERE pet.element_name = c_element_name
9863: AND pet.element_type_id = piv.element_type_id
9864: AND piv.name = c_input_val_name

Line 9885: ,pay_element_entries_f peef

9881: ,c_eff_date DATE) IS
9882: SELECT pet.element_name
9883: ,peev.screen_entry_value
9884: FROM pay_element_types_f pet
9885: ,pay_element_entries_f peef
9886: ,pay_element_entry_values_f peev
9887: WHERE peev.element_entry_value_id = c_element_entry_value_id
9888: AND peev.element_entry_id = peef.element_entry_id
9889: AND peef.element_type_id = pet.element_type_id

Line 9903: ,pay_element_entries_f peef

9899: ,c_eff_date DATE) IS
9900: SELECT pet.element_name
9901: ,peev.screen_entry_value
9902: FROM pay_element_types_f pet
9903: ,pay_element_entries_f peef
9904: ,pay_element_entry_values_f peev
9905: WHERE peef.element_entry_id = c_element_entry_id
9906: AND peev.element_entry_id = peef.element_entry_id
9907: AND peef.element_type_id = pet.element_type_id

Line 10200: OPEN csr_get_table_id('PAY_ELEMENT_ENTRIES_F');

10196: --Fnd_file.put_line(FND_FILE.LOG,' Total Change Records :'||l_detail_tab.COUNT);
10197: --Fnd_file.put_line(FND_FILE.LOG,' Change Records for Assignment : '||l_assignment_id);
10198: sort_changes(l_detail_tab);
10199: --
10200: OPEN csr_get_table_id('PAY_ELEMENT_ENTRIES_F');
10201: FETCH csr_get_table_id INTO l_table1;
10202: CLOSE csr_get_table_id;
10203: --
10204: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');

Line 14068: ,pay_element_entries_f peef

14064: ,c_eff_date DATE) IS
14065: SELECT peev.screen_entry_value
14066: FROM pay_element_types_f pet
14067: ,pay_input_values_f piv
14068: ,pay_element_entries_f peef
14069: ,pay_element_entry_values_f peev
14070: WHERE pet.element_name = c_element_name
14071: AND pet.element_type_id = piv.element_type_id
14072: AND piv.name = c_input_val_name

Line 14093: ,pay_element_entries_f peef

14089: ,c_eff_date DATE) IS
14090: SELECT pet.element_name
14091: ,peev.screen_entry_value
14092: FROM pay_element_types_f pet
14093: ,pay_element_entries_f peef
14094: ,pay_element_entry_values_f peev
14095: WHERE peev.element_entry_value_id = c_element_entry_value_id
14096: AND peev.element_entry_id = peef.element_entry_id
14097: AND peef.element_type_id = pet.element_type_id

Line 14111: ,pay_element_entries_f peef

14107: ,c_eff_date DATE) IS
14108: SELECT pet.element_name
14109: ,peev.screen_entry_value
14110: FROM pay_element_types_f pet
14111: ,pay_element_entries_f peef
14112: ,pay_element_entry_values_f peev
14113: WHERE peef.element_entry_id = c_element_entry_id
14114: AND peev.element_entry_id = peef.element_entry_id
14115: AND peef.element_type_id = pet.element_type_id

Line 14714: ,pay_element_entries_f pee1

14710: FROM pay_run_results rr1 -- Retro element
14711: ,pay_element_span_usages esu
14712: ,pay_retro_component_usages rcu
14713: ,pay_retro_components rc
14714: ,pay_element_entries_f pee1
14715: ,pay_assignment_actions paa1
14716: ,pay_payroll_actions ppa1
14717: ,per_time_periods ptp
14718: WHERE --paa1.source_action_id = paa.assignment_action_id

Line 14749: ,pay_element_entries_f pee1

14745: FROM pay_run_results rr1
14746: ,pay_element_span_usages esu
14747: ,pay_retro_component_usages rcu
14748: ,pay_retro_components rc
14749: ,pay_element_entries_f pee1
14750: ,pay_assignment_actions paa
14751: ,pay_payroll_actions ppa
14752: ,per_time_periods ptp
14753: WHERE paa.assignment_action_id = c_assignment_action_id