APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 1676: from pay_element_types_f pet

1672: pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date)) rate, /* 5599310 */
1673: prr.run_result_id,
1674: paa.source_action_id,
1675: paa2.tax_unit_id /*Bug 3935471*/
1676: from pay_element_types_f pet
1677: ,pay_input_values_f piv
1678: ,pay_element_classifications pec
1679: ,pay_assignment_actions paa
1680: ,pay_assignment_actions paa2 /*Bug 3935471*/

Line 2377: l_element_type_id pay_element_types_f.element_type_id%TYPE;

2373: )
2374: RETURN NUMBER
2375: IS
2376:
2377: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2378: l_input_value_id pay_input_values_f.input_value_id%TYPE;
2379:
2380: l_result number := NULL;
2381: l_temp NUMBER := NULL;

Line 2385: (c_element_type_id pay_element_types_f.element_type_id%TYPE

2381: l_temp NUMBER := NULL;
2382:
2383: /* Bug 5987877 - Added Check for Input with Name - Hours */
2384: CURSOR get_hours_input_value
2385: (c_element_type_id pay_element_types_f.element_type_id%TYPE
2386: ,c_effective_date date)
2387: IS
2388: SELECT pivf.input_value_id
2389: ,pivf.name

Line 2459: l_element_type_id pay_element_types_f.element_type_id%TYPE;

2455: )
2456: RETURN NUMBER
2457: IS
2458:
2459: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2460: l_input_value_id pay_input_values_f.input_value_id%TYPE;
2461:
2462: l_result number := NULL;
2463:

Line 2465: (c_element_type_id pay_element_types_f.element_type_id%TYPE

2461:
2462: l_result number := NULL;
2463:
2464: CURSOR get_rate_input_value
2465: (c_element_type_id pay_element_types_f.element_type_id%TYPE
2466: ,c_effective_date date)
2467: IS
2468: SELECT pivf.input_value_id
2469: FROM pay_input_values_f pivf