APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 521: ,pay_element_types_f pet

517: ,ppa.payroll_id payroll_id
518: ,pap.business_group_id business_group_id
519: ,pap.accrual_plan_id accrual_plan_id
520: FROM pay_accrual_plans pap
521: ,pay_element_types_f pet
522: ,pay_element_links_f pel
523: ,pay_element_entries_f pee
524: ,pay_assignment_actions paa
525: ,pay_payroll_actions ppa

Line 720: ,pay_element_types_f pet

716: ,pay_payroll_actions ppa
717: ,pay_run_results prr
718: ,pay_run_result_values prrv
719: ,per_time_periods ptp
720: ,pay_element_types_f pet
721: ,pay_input_values_f piv
722: ,pay_element_entries_f pee
723: ,per_absence_attendance_types pat
724: ,per_absence_attendances pab

Line 1283: FROM PAY_ELEMENT_TYPES_F PET,

1279:
1280: /*Added CURSOR c_med_added_to_net_pay for Bug 15951974 */
1281: CURSOR c_med_added_to_net_pay IS
1282: SELECT PRV2.RESULT_VALUE
1283: FROM PAY_ELEMENT_TYPES_F PET,
1284: PAY_ELEMENT_CLASSIFICATIONS PEC,
1285: PAY_INPUT_VALUES_F PIV,
1286: PAY_INPUT_VALUES_F PIV2,
1287: PAY_RUN_RESULTS PRR,

Line 2717: FROM pay_element_types_f

2713: --Find the element type id
2714: CURSOR c_element_type_id
2715: IS
2716: SELECT element_type_id
2717: FROM pay_element_types_f
2718: WHERE element_name='ESI Information'
2719: AND legislation_code = 'IN'
2720: AND p_payroll_date between effective_start_date and effective_end_date;
2721:

Line 3683: FROM pay_element_types_f

3679: --Find the element type id
3680: CURSOR c_element_type_id
3681: IS
3682: SELECT element_type_id
3683: FROM pay_element_types_f
3684: WHERE element_name ='Professional Tax Information'
3685: AND legislation_code = 'IN'
3686: AND p_payroll_date BETWEEN effective_start_date AND effective_end_date;
3687:

Line 3737: l_element_type_id pay_element_types_f.element_type_id%TYPE;

3733: l_full_name per_people_f.full_name%TYPE;
3734: l_person_id per_people_f.person_id%TYPE;
3735: l_source_id hr_organization_units.organization_id%TYPE;
3736: l_pt_org_name hr_organization_units.name%TYPE;
3737: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3738: l_state_iv_id pay_input_values_f.input_value_id%TYPE;
3739: l_reason_iv_id pay_input_values_f.input_value_id%TYPE;
3740: l_asg_id per_assignments_f.assignment_id%TYPE;
3741: l_message VARCHAR2(255);