APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 718: ,pay_run_result_values prrv

714: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
715: FROM pay_assignment_actions paa
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

Line 1288: PAY_RUN_RESULT_VALUES PRV,

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'
1291: AND PEC.CLASSIFICATION_NAME='Fringe Benefits'
1292: AND PEC.CLASSIFICATION_ID=PET.CLASSIFICATION_ID

Line 1289: PAY_RUN_RESULT_VALUES PRV2

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'
1291: AND PEC.CLASSIFICATION_NAME='Fringe Benefits'
1292: AND PEC.CLASSIFICATION_ID=PET.CLASSIFICATION_ID
1293: AND PET.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID

Line 2743: FROM pay_run_result_values prr1

2739: --Find the actual remarks
2740: CURSOR c_remarks(p_run_result_id NUMBER,p_org_iv_id NUMBER,p_rem_iv_id NUMBER,p_org_id NUMBER)
2741: IS
2742: SELECT prr2.result_value
2743: FROM pay_run_result_values prr1
2744: ,pay_run_result_values prr2
2745: WHERE prr1.run_result_id = p_run_result_id
2746: AND prr1.input_value_id = p_org_iv_id
2747: AND prr2.run_result_id = prr1.run_result_id

Line 2744: ,pay_run_result_values prr2

2740: CURSOR c_remarks(p_run_result_id NUMBER,p_org_iv_id NUMBER,p_rem_iv_id NUMBER,p_org_id NUMBER)
2741: IS
2742: SELECT prr2.result_value
2743: FROM pay_run_result_values prr1
2744: ,pay_run_result_values prr2
2745: WHERE prr1.run_result_id = p_run_result_id
2746: AND prr1.input_value_id = p_org_iv_id
2747: AND prr2.run_result_id = prr1.run_result_id
2748: AND prr2.input_value_id = p_rem_iv_id

Line 3713: FROM pay_run_result_values prr1

3709: ,p_rem_iv_id NUMBER
3710: ,p_jur_code VARCHAR2)
3711: IS
3712: SELECT prr2.result_value
3713: FROM pay_run_result_values prr1
3714: ,pay_run_result_values prr2
3715: WHERE prr1.run_result_id = p_run_result_id
3716: AND prr1.input_value_id = p_state_iv_id
3717: AND prr2.run_result_id = prr1.run_result_id

Line 3714: ,pay_run_result_values prr2

3710: ,p_jur_code VARCHAR2)
3711: IS
3712: SELECT prr2.result_value
3713: FROM pay_run_result_values prr1
3714: ,pay_run_result_values prr2
3715: WHERE prr1.run_result_id = p_run_result_id
3716: AND prr1.input_value_id = p_state_iv_id
3717: AND prr2.run_result_id = prr1.run_result_id
3718: AND prr2.input_value_id = p_rem_iv_id