APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 2292: ,pay_element_types_f adj_petf

2288: FROM pay_assignment_actions bal_assact
2289: -- ,pay_payroll_actions bact
2290: ,pay_assignment_actions assact
2291: -- ,pay_payroll_actions pact
2292: ,pay_element_types_f adj_petf
2293: ,pay_run_results adj_prr
2294: WHERE bal_assact.assignment_action_id = c_ass_act_id -- assignment_action_id
2295: --and bal_assact.payroll_action_id = bact.payroll_action_id
2296: --and assact.payroll_action_id = pact.payroll_action_id

Line 5682: ,pay_element_types_f pet

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

Line 6023: ,pay_element_types_f pet

6019: ,min(decode(piv.name, 'Period', rrv.RESULT_VALUE, null)) Period
6020: FROM pay_run_results prr
6021: ,pay_run_result_values rrv
6022: ,pay_input_values_f piv
6023: ,pay_element_types_f pet
6024: WHERE prr.run_result_id = rrv.run_result_id
6025: AND rrv.input_value_id + 0 = piv.input_value_id
6026: AND piv.element_type_id = pet.element_type_id
6027: AND prr.element_type_id = pet.element_type_id

Line 6189: FROM pay_element_types_f pet

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

Line 6215: FROM pay_element_types_f pet

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

Line 6233: FROM pay_element_types_f pet

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

Line 8476: FROM pay_element_types_f pet

8472: ,c_input_val_name VARCHAR2
8473: ,c_assignment_id NUMBER
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

Line 8502: FROM pay_element_types_f pet

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

Line 8520: FROM pay_element_types_f pet

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