DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE dependencies on PAY_RUN_RESULT_VALUES

Line 124: , pay_run_result_values prrv

120: SELECT result_value
121: FROM pay_element_types_f pet
122: , pay_element_entries_f pee
123: , pay_run_results prr
124: , pay_run_result_values prrv
125: , pay_input_values_f piv
126: WHERE pet.element_type_id = pee.element_type_id
127: AND pet.element_type_id = prr.element_type_id
128: AND pee.element_entry_id = prr.element_entry_id

Line 8003: FROM pay_run_result_values TARGET

7999:
8000: CURSOR CSR_GET_ASG_DETAILS(l_assignment_action_id number,l_source_id number,l_balance_type_id number) IS
8001: SELECT
8002: count(TARGET.result_value )
8003: FROM pay_run_result_values TARGET
8004: , pay_balance_feeds_f FEED
8005: , pay_run_results RR
8006: , pay_assignment_actions ASSACT
8007: , pay_assignment_actions BAL_ASSACT