APPS.PAY_AU_TERMINATIONS dependencies on PAY_INPUT_VALUES_F

Line 1041: pay_input_values_f piv,

1037: to_date(peev2.screen_entry_value,'YYYY/MM/DD HH24:MI:SS')
1038: from pay_element_types_f pet,
1039: pay_element_entries_f peef,
1040: pay_element_links_f pel,
1041: pay_input_values_f piv,
1042: pay_input_values_f piv1,
1043: pay_input_values_f piv2,
1044: pay_element_entry_values_f peev,
1045: pay_element_entry_values_f peev1,

Line 1042: pay_input_values_f piv1,

1038: from pay_element_types_f pet,
1039: pay_element_entries_f peef,
1040: pay_element_links_f pel,
1041: pay_input_values_f piv,
1042: pay_input_values_f piv1,
1043: pay_input_values_f piv2,
1044: pay_element_entry_values_f peev,
1045: pay_element_entry_values_f peev1,
1046: pay_element_entry_values_f peev2

Line 1043: pay_input_values_f piv2,

1039: pay_element_entries_f peef,
1040: pay_element_links_f pel,
1041: pay_input_values_f piv,
1042: pay_input_values_f piv1,
1043: pay_input_values_f piv2,
1044: pay_element_entry_values_f peev,
1045: pay_element_entry_values_f peev1,
1046: pay_element_entry_values_f peev2
1047: where peef.assignment_id = c_assignment_id

Line 1298: , pay_input_values_f pivf

1294: ,p_accrual_plan_id number
1295: ) is
1296: select to_number(hrl.description)
1297: from pay_element_types_f petf
1298: , pay_input_values_f pivf
1299: , pay_accrual_plans pap
1300: , hr_lookups hrl
1301: , pay_element_classifications pec
1302: where pap.accrual_plan_id = p_accrual_plan_id

Line 2143: pay_input_values_f piv,

2139:
2140: cursor csr_check_trans is
2141: select 1
2142: from pay_element_types_f pet,
2143: pay_input_values_f piv,
2144: pay_element_entries_f pee,
2145: pay_element_entry_values_f peev
2146: where pee.assignment_id = p_assignment_id
2147: and pet.element_type_id = piv.element_type_id

Line 2208: pay_input_values_f piv,

2204:
2205: cursor csr_get_etp_entry is
2206: select peev.screen_entry_value, count(peev.screen_entry_value) etp_no
2207: from pay_element_types_f pet,
2208: pay_input_values_f piv,
2209: pay_element_entries_f pee,
2210: pay_element_entry_values_f peev
2211: where pee.assignment_id = p_assignment_id
2212: and pet.element_type_id = piv.element_type_id

Line 3236: pay_input_values_f piv,

3232: pay_element_entry_values_f peev,
3233: pay_element_entry_values_f peev1,
3234: pay_element_entry_values_f peev2,
3235: pay_element_types_f pet,
3236: pay_input_values_f piv,
3237: pay_input_values_f piv1,
3238: pay_input_values_f piv2
3239: where
3240: ptp.payroll_id = ppa.payroll_id

Line 3237: pay_input_values_f piv1,

3233: pay_element_entry_values_f peev1,
3234: pay_element_entry_values_f peev2,
3235: pay_element_types_f pet,
3236: pay_input_values_f piv,
3237: pay_input_values_f piv1,
3238: pay_input_values_f piv2
3239: where
3240: ptp.payroll_id = ppa.payroll_id
3241: and ppa.payroll_action_id = pac.payroll_action_id

Line 3238: pay_input_values_f piv2

3234: pay_element_entry_values_f peev2,
3235: pay_element_types_f pet,
3236: pay_input_values_f piv,
3237: pay_input_values_f piv1,
3238: pay_input_values_f piv2
3239: where
3240: ptp.payroll_id = ppa.payroll_id
3241: and ppa.payroll_action_id = pac.payroll_action_id
3242: and pee.assignment_id = p_assignment_id

Line 3325: pay_input_values_f piv,

3321:
3322: cursor au_count_etps is
3323: select count(pee.element_entry_id)
3324: from pay_element_types_f pet,
3325: pay_input_values_f piv,
3326: pay_element_entries_f pee,
3327: pay_element_entry_values_f peev,
3328: pay_input_values_f piv2,
3329: pay_element_entry_values_f peev2

Line 3328: pay_input_values_f piv2,

3324: from pay_element_types_f pet,
3325: pay_input_values_f piv,
3326: pay_element_entries_f pee,
3327: pay_element_entry_values_f peev,
3328: pay_input_values_f piv2,
3329: pay_element_entry_values_f peev2
3330: where pee.assignment_id = p_assignment_id
3331: and pet.element_type_id = piv.element_type_id
3332: and pet.element_name = 'ETP on Termination'