[Home] [Help]
5677: ,p_detail_tab IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type) IS
5678: CURSOR csr_get_element_entries(c_assignment_id NUMBER
5679: ,c_eff_date DATE) IS
5680: SELECT peef.element_entry_id
5681: FROM pay_element_entries_f peef
5682: ,pay_element_types_f pet
5683: WHERE pet.element_name IN ('Holiday Coupons','Incidental Income Decrease','Additional Allowance','Company Car Private Usage')
5684: AND pet.legislation_code = 'NL'
5685: AND peef.assignment_id = c_assignment_id
5713: l_table3 pay_dated_tables.dated_table_id%type;
5714: --
5715: BEGIN
5716: --
5717: OPEN csr_get_table_id('PAY_ELEMENT_ENTRIES_F');
5718: FETCH csr_get_table_id INTO l_table1;
5719: CLOSE csr_get_table_id;
5720: --
5721: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');
5725: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');
5726: FETCH csr_get_table_id INTO l_table3;
5727: CLOSE csr_get_table_id;
5728: --
5729: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRIES_F : '||l_table1);
5730: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRY_VALUES_F : '||l_table1);
5731: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PER_ASSIGNMENT_EXTRA_INFO : '||l_table1);
5732: l_cnt := 1;
5733: FOR c_rec IN csr_get_element_entries(p_assignment_id,p_end_date) LOOP
6038: ,c_date DATE) IS
6039: SELECT DISTINCT ptp.start_date start_date
6040: ,ptp.end_date end_date
6041: FROM pay_run_results prr
6042: ,pay_element_entries_f pee
6043: ,pay_assignment_actions paa
6044: ,pay_payroll_actions ppa
6045: ,per_time_periods ptp
6046: WHERE prr.assignment_action_id = paa.assignment_action_id
6063: ,pay_run_results rr2 -- Normal Element
6064: ,pay_element_span_usages esu
6065: ,pay_retro_component_usages rcu
6066: ,pay_retro_components rc
6067: ,pay_element_entries_f pee1
6068: ,pay_element_entries_f pee2
6069: ,pay_retro_assignments pra
6070: ,pay_retro_entries pre
6071: WHERE rr1.assignment_action_id = c_assignment_action_id
6064: ,pay_element_span_usages esu
6065: ,pay_retro_component_usages rcu
6066: ,pay_retro_components rc
6067: ,pay_element_entries_f pee1
6068: ,pay_element_entries_f pee2
6069: ,pay_retro_assignments pra
6070: ,pay_retro_entries pre
6071: WHERE rr1.assignment_action_id = c_assignment_action_id
6072: AND rr2.assignment_action_id = rr1.assignment_action_id
6095: FROM pay_run_results rr1 -- Retro element
6096: ,pay_element_span_usages esu
6097: ,pay_retro_component_usages rcu
6098: ,pay_retro_components rc
6099: ,pay_element_entries_f pee1
6100: ,pay_assignment_actions paa
6101: ,pay_payroll_actions ppa
6102: ,per_time_periods ptp
6103: WHERE paa.assignment_action_id = c_assignment_action_id
6178: --
6179: CURSOR csr_get_table_id(c_table_name VARCHAR2) IS
6180: SELECT dated_table_id
6181: FROM pay_dated_tables
6182: WHERE TABLE_NAME = c_table_name; -- in ('PAY_ELEMENT_ENTRY_VALUES_F','PAY_ELEMENT_ENTRIES_F');
6183: --
6184: CURSOR csr_get_element_det(c_element_name VARCHAR2
6185: ,c_input_val_name VARCHAR2
6186: ,c_assignment_id NUMBER
6187: ,c_eff_date DATE) IS
6188: SELECT peev.screen_entry_value
6189: FROM pay_element_types_f pet
6190: ,pay_input_values_f piv
6191: ,pay_element_entries_f peef
6192: ,pay_element_entry_values_f peev
6193: WHERE pet.element_name = c_element_name
6194: AND pet.element_type_id = piv.element_type_id
6195: AND piv.name = c_input_val_name
6212: ,c_eff_date DATE) IS
6213: SELECT pet.element_name
6214: ,peev.screen_entry_value
6215: FROM pay_element_types_f pet
6216: ,pay_element_entries_f peef
6217: ,pay_element_entry_values_f peev
6218: WHERE peev.element_entry_value_id = c_element_entry_value_id
6219: AND peev.element_entry_id = peef.element_entry_id
6220: AND peef.element_type_id = pet.element_type_id
6230: ,c_eff_date DATE) IS
6231: SELECT pet.element_name
6232: ,peev.screen_entry_value
6233: FROM pay_element_types_f pet
6234: ,pay_element_entries_f peef
6235: ,pay_element_entry_values_f peev
6236: WHERE peef.element_entry_id = c_element_entry_id
6237: AND peev.element_entry_id = peef.element_entry_id
6238: AND peef.element_type_id = pet.element_type_id
6414: --Fnd_file.put_line(FND_FILE.LOG,' Total Change Records :'||l_detail_tab.COUNT);
6415: --Fnd_file.put_line(FND_FILE.LOG,' Change Records for Assignment : '||l_assignment_id);
6416: sort_changes(l_detail_tab);
6417: --
6418: OPEN csr_get_table_id('PAY_ELEMENT_ENTRIES_F');
6419: FETCH csr_get_table_id INTO l_table1;
6420: CLOSE csr_get_table_id;
6421: --
6422: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');
8474: ,c_eff_date DATE) IS
8475: SELECT peev.screen_entry_value
8476: FROM pay_element_types_f pet
8477: ,pay_input_values_f piv
8478: ,pay_element_entries_f peef
8479: ,pay_element_entry_values_f peev
8480: WHERE pet.element_name = c_element_name
8481: AND pet.element_type_id = piv.element_type_id
8482: AND piv.name = c_input_val_name
8499: ,c_eff_date DATE) IS
8500: SELECT pet.element_name
8501: ,peev.screen_entry_value
8502: FROM pay_element_types_f pet
8503: ,pay_element_entries_f peef
8504: ,pay_element_entry_values_f peev
8505: WHERE peev.element_entry_value_id = c_element_entry_value_id
8506: AND peev.element_entry_id = peef.element_entry_id
8507: AND peef.element_type_id = pet.element_type_id
8517: ,c_eff_date DATE) IS
8518: SELECT pet.element_name
8519: ,peev.screen_entry_value
8520: FROM pay_element_types_f pet
8521: ,pay_element_entries_f peef
8522: ,pay_element_entry_values_f peev
8523: WHERE peef.element_entry_id = c_element_entry_id
8524: AND peev.element_entry_id = peef.element_entry_id
8525: AND peef.element_type_id = pet.element_type_id