APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 721: ,pay_input_values_f piv

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

Line 1285: PAY_INPUT_VALUES_F PIV,

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,
1288: PAY_RUN_RESULT_VALUES PRV,
1289: PAY_RUN_RESULT_VALUES PRV2

Line 1286: PAY_INPUT_VALUES_F PIV2,

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,
1288: PAY_RUN_RESULT_VALUES PRV,
1289: PAY_RUN_RESULT_VALUES PRV2
1290: WHERE PEC.LEGISLATION_CODE='IN'

Line 2726: FROM pay_input_values_f

2722: --Find the input value id for Reason for Exemption, Organization and Remarks
2723: CURSOR c_iv_id(p_element_type_id NUMBER,p_name VARCHAR2)
2724: IS
2725: SELECT input_value_id
2726: FROM pay_input_values_f
2727: WHERE element_type_id = p_element_type_id
2728: AND name = p_name
2729: AND p_payroll_date BETWEEN effective_start_date AND effective_end_date;
2730:

Line 3693: FROM pay_input_values_f

3689: CURSOR c_iv_id(p_element_type_id NUMBER
3690: ,p_name VARCHAR2)
3691: IS
3692: SELECT input_value_id
3693: FROM pay_input_values_f
3694: WHERE element_type_id = p_element_type_id
3695: AND name = p_name
3696: AND p_payroll_date BETWEEN effective_start_date AND effective_end_date;
3697:

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

Line 3739: l_reason_iv_id pay_input_values_f.input_value_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);
3742: l_procedure VARCHAR2(100);
3743: