DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 717: ,pay_run_results prr

713: ,decode(pet.processing_type,'R',least(pab.date_end,PTP.END_DATE),pab.date_end) end_date
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

Line 1287: PAY_RUN_RESULTS PRR,

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

Line 2735: FROM pay_run_results

2731: --Find the run result id
2732: CURSOR c_run_result_id(p_element_type_id NUMBER)
2733: IS
2734: SELECT run_result_id
2735: FROM pay_run_results
2736: WHERE assignment_action_id=p_assignment_action_id
2737: AND element_type_id=p_element_type_id;
2738:
2739: --Find the actual remarks

Line 3702: FROM pay_run_results

3698: --Find the run result id
3699: CURSOR c_run_result_id(p_element_type_id NUMBER)
3700: IS
3701: SELECT run_result_id
3702: FROM pay_run_results
3703: WHERE assignment_action_id = p_assignment_action_id
3704: AND element_type_id = p_element_type_id;
3705:
3706: --Find the actual Exemption Reason