APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 451: ,pay_element_types_f pet

447: ,ppa.payroll_id payroll_id
448: ,pap.business_group_id business_group_id
449: ,pap.accrual_plan_id accrual_plan_id
450: FROM pay_accrual_plans pap
451: ,pay_element_types_f pet
452: ,pay_element_links_f pel
453: ,pay_element_entries_f pee
454: ,pay_assignment_actions paa
455: ,pay_payroll_actions ppa

Line 650: ,pay_element_types_f pet

646: ,pay_payroll_actions ppa
647: ,pay_run_results prr
648: ,pay_run_result_values prrv
649: ,per_time_periods ptp
650: ,pay_element_types_f pet
651: ,pay_input_values_f piv
652: ,pay_element_entries_f pee
653: ,per_absence_attendance_types pat
654: ,per_absence_attendances pab

Line 2505: FROM pay_element_types_f

2501: --Find the element type id
2502: CURSOR c_element_type_id
2503: IS
2504: SELECT element_type_id
2505: FROM pay_element_types_f
2506: WHERE element_name='ESI Information'
2507: AND legislation_code = 'IN'
2508: AND p_payroll_date between effective_start_date and effective_end_date;
2509:

Line 3463: FROM pay_element_types_f

3459: --Find the element type id
3460: CURSOR c_element_type_id
3461: IS
3462: SELECT element_type_id
3463: FROM pay_element_types_f
3464: WHERE element_name ='Professional Tax Information'
3465: AND legislation_code = 'IN'
3466: AND p_payroll_date BETWEEN effective_start_date AND effective_end_date;
3467:

Line 3517: l_element_type_id pay_element_types_f.element_type_id%TYPE;

3513: l_full_name per_people_f.full_name%TYPE;
3514: l_person_id per_people_f.person_id%TYPE;
3515: l_source_id hr_organization_units.organization_id%TYPE;
3516: l_pt_org_name hr_organization_units.name%TYPE;
3517: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3518: l_state_iv_id pay_input_values_f.input_value_id%TYPE;
3519: l_reason_iv_id pay_input_values_f.input_value_id%TYPE;
3520: l_asg_id per_assignments_f.assignment_id%TYPE;
3521: l_message VARCHAR2(255);