APPS.HR_NZ_HOLIDAYS dependencies on PAY_ELEMENT_TYPES_F

Line 164: pay_element_types_f pet,

160: ,p_effective_date IN DATE) IS
161: SELECT LEAST(PEE.EFFECTIVE_START_DATE)
162: FROM pay_element_entries_f pee,
163: pay_element_links_f pel,
164: pay_element_types_f pet,
165: pay_accrual_plans pap
166: where pee.element_link_id = pel.element_link_id
167: and pel.element_type_id = pet.element_type_id
168: and pet.element_type_id = pap.accrual_plan_element_type_id

Line 217: pay_element_types_f pet

213: SELECT pap.accrual_plan_id
214: FROM pay_accrual_plans pap,
215: pay_element_entries_f pee,
216: pay_element_links_f pel,
217: pay_element_types_f pet
218: WHERE pee.assignment_id = p_assignment_id
219: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
220: AND pel.element_link_id = pee.element_link_id
221: AND pel.element_type_id = pet.element_type_id

Line 1057: pay_element_types_f pet

1053: SELECT pap.accrual_plan_id
1054: FROM pay_accrual_plans pap,
1055: pay_element_entries_f pee,
1056: pay_element_links_f pel,
1057: pay_element_types_f pet
1058: WHERE pel.element_link_id = pee.element_link_id
1059: AND pel.element_type_id = pet.element_type_id
1060: AND pee.assignment_id = c_assignment_id
1061: AND pet.element_type_id = pap.accrual_plan_element_type_id

Line 1500: FROM pay_element_types_f pet

1496: RETURN NUMBER IS
1497:
1498: CURSOR csr_accrual_record_element(c_effective_date DATE) IS
1499: SELECT pet.element_type_id
1500: FROM pay_element_types_f pet
1501: WHERE pet.element_name = 'Annual Leave Accrual Record'
1502: AND c_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;
1503:
1504: CURSOR csr_accrual_record_iv(c_element_type_id pay_input_values_f.element_type_id%TYPE

Line 2069: , pay_element_types_f pet

2065: select pap.accrual_plan_id
2066: from pay_accrual_plans pap
2067: , pay_element_entries_f pee
2068: , pay_element_links_f pel
2069: , pay_element_types_f pet
2070: where pee.assignment_id = p_assignment_id
2071: and p_effective_date between pee.effective_start_date
2072: and pee.effective_end_date
2073: and pel.element_link_id = pee.element_link_id

Line 2111: , pay_element_types_f et2 -- Annual Leave Pay element

2107: , pay_payroll_actions pa -- payroll action for -- absence element entry
2108: , per_time_periods tp
2109: , pay_run_results rr2 -- run result for Annual -- Leave Pay element type
2110: , pay_run_result_values rrv2 -- run result value for -- Annual Leave Pay element -- pay value ,
2111: , pay_element_types_f et2 -- Annual Leave Pay element
2112: , pay_input_values_f iv2 -- Pay Value input value
2113: where ap.accrual_plan_id = p_accrual_plan_id
2114: and eev.input_value_id = ap.pto_input_value_id
2115: and ee.element_entry_id = eev.element_entry_id

Line 3510: , pay_element_types_f pet

3506: select prv.result_value
3507: from pay_run_result_values prv
3508: , pay_run_results prr
3509: , pay_input_values_f piv
3510: , pay_element_types_f pet
3511: , pay_element_entries_f pee
3512: where pet.element_name = 'Annual Leave Pay'
3513: and pet.legislation_code = 'NZ'
3514: and pet.element_type_id = piv.element_type_id

Line 3753: ,pay_element_types_f pet

3749: select
3750: sum(nvl(to_number(pev1.screen_entry_value),0))
3751: from
3752: pay_accrual_plans pap
3753: ,pay_element_types_f pet
3754: ,pay_element_links_f pel
3755: ,pay_input_values_f piv1
3756: ,pay_input_values_f piv2
3757: ,pay_element_entries_f pee