APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 2880: from pay_element_types_f pet

2876: 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 */
2877: prr.run_result_id,
2878: paa.source_action_id,
2879: paa2.tax_unit_id /*Bug 3935471*/
2880: from pay_element_types_f pet
2881: ,pay_input_values_f piv
2882: ,pay_element_classifications pec
2883: ,pay_assignment_actions paa
2884: ,pay_assignment_actions paa2 /*Bug 3935471*/

Line 3581: l_element_type_id pay_element_types_f.element_type_id%TYPE;

3577: )
3578: RETURN NUMBER
3579: IS
3580:
3581: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3582: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3583:
3584: l_result number := NULL;
3585: l_temp NUMBER := NULL;

Line 3589: (c_element_type_id pay_element_types_f.element_type_id%TYPE

3585: l_temp NUMBER := NULL;
3586:
3587: /* Bug 5987877 - Added Check for Input with Name - Hours */
3588: CURSOR get_hours_input_value
3589: (c_element_type_id pay_element_types_f.element_type_id%TYPE
3590: ,c_effective_date date)
3591: IS
3592: SELECT pivf.input_value_id
3593: ,pivf.name

Line 3663: l_element_type_id pay_element_types_f.element_type_id%TYPE;

3659: )
3660: RETURN NUMBER
3661: IS
3662:
3663: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3664: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3665:
3666: l_result number := NULL;
3667:

Line 3669: (c_element_type_id pay_element_types_f.element_type_id%TYPE

3665:
3666: l_result number := NULL;
3667:
3668: CURSOR get_rate_input_value
3669: (c_element_type_id pay_element_types_f.element_type_id%TYPE
3670: ,c_effective_date date)
3671: IS
3672: SELECT pivf.input_value_id
3673: FROM pay_input_values_f pivf