APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 651: ,pay_input_values_f piv

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
655: WHERE paa.assignment_action_id = p_assg_act_id

Line 2514: FROM pay_input_values_f

2510: --Find the input value id for Reason for Exemption, Organization and Remarks
2511: CURSOR c_iv_id(p_element_type_id NUMBER,p_name VARCHAR2)
2512: IS
2513: SELECT input_value_id
2514: FROM pay_input_values_f
2515: WHERE element_type_id = p_element_type_id
2516: AND name = p_name
2517: AND p_payroll_date BETWEEN effective_start_date AND effective_end_date;
2518:

Line 3473: FROM pay_input_values_f

3469: CURSOR c_iv_id(p_element_type_id NUMBER
3470: ,p_name VARCHAR2)
3471: IS
3472: SELECT input_value_id
3473: FROM pay_input_values_f
3474: WHERE element_type_id = p_element_type_id
3475: AND name = p_name
3476: AND p_payroll_date BETWEEN effective_start_date AND effective_end_date;
3477:

Line 3518: l_state_iv_id pay_input_values_f.input_value_id%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);
3522: l_procedure VARCHAR2(100);

Line 3519: l_reason_iv_id pay_input_values_f.input_value_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);
3522: l_procedure VARCHAR2(100);
3523: