APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 3461: ,pay_element_types_f adj_petf

3457: FROM pay_assignment_actions bal_assact
3458: -- ,pay_payroll_actions bact
3459: ,pay_assignment_actions assact
3460: -- ,pay_payroll_actions pact
3461: ,pay_element_types_f adj_petf
3462: ,pay_run_results adj_prr
3463: WHERE bal_assact.assignment_action_id = c_ass_act_id -- assignment_action_id
3464: --and bal_assact.payroll_action_id = bact.payroll_action_id
3465: --and assact.payroll_action_id = pact.payroll_action_id

Line 9347: ,pay_element_types_f pet

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
9351: AND peef.element_type_id = pet.element_type_id

Line 9691: ,pay_element_types_f pet

9687: ,min(decode(piv.name, 'Period', rrv.RESULT_VALUE, null)) Period
9688: FROM pay_run_results prr
9689: ,pay_run_result_values rrv
9690: ,pay_input_values_f piv
9691: ,pay_element_types_f pet
9692: WHERE prr.run_result_id = rrv.run_result_id
9693: AND rrv.input_value_id + 0 = piv.input_value_id
9694: AND piv.element_type_id = pet.element_type_id
9695: AND prr.element_type_id = pet.element_type_id

Line 9858: FROM pay_element_types_f pet

9854: ,c_input_val_name VARCHAR2
9855: ,c_assignment_id NUMBER
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

Line 9884: FROM pay_element_types_f pet

9880: CURSOR csr_get_element_name2(c_element_entry_value_id NUMBER
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

Line 9902: FROM pay_element_types_f pet

9898: CURSOR csr_get_element_name1(c_element_entry_id NUMBER
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

Line 9962: ,pay_element_types_f pet

9958: ,c_eff_date DATE) IS
9959: SELECT prrv.result_value
9960: FROM pay_run_result_values prrv
9961: ,pay_input_values_f piv
9962: ,pay_element_types_f pet
9963: ,pay_run_results prr
9964: WHERE pet.element_name = 'Small Job Indicator'
9965: AND pet.element_type_id = piv.element_type_id
9966: AND piv.name = 'Exempt Small Jobs'

Line 14066: FROM pay_element_types_f pet

14062: ,c_input_val_name VARCHAR2
14063: ,c_assignment_id NUMBER
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

Line 14092: FROM pay_element_types_f pet

14088: CURSOR csr_get_element_name2(c_element_entry_value_id NUMBER
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

Line 14110: FROM pay_element_types_f pet

14106: CURSOR csr_get_element_name1(c_element_entry_id NUMBER
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

Line 14161: ,pay_element_types_f pet

14157: ,c_eff_date DATE) IS
14158: SELECT prrv.result_value
14159: FROM pay_run_result_values prrv
14160: ,pay_input_values_f piv
14161: ,pay_element_types_f pet
14162: ,pay_run_results prr
14163: WHERE pet.element_name = 'Small Job Indicator'
14164: AND pet.element_type_id = piv.element_type_id
14165: AND piv.name = 'Exempt Small Jobs'