DBA Data[Home] [Help]

APPS.PQP_GB_TP_CONTRIBUTION_REPORT dependencies on PAY_ELEMENT_ENTRIES_F

Line 504: FROM pay_element_entries_f peef

500: ,pay_run_result_values prrv
501: WHERE prr.assignment_action_id IN
502: (
503: SELECT paa.ASSIGNMENT_ACTION_ID
504: FROM pay_element_entries_f peef
505: ,per_time_periods ptp
506: ,pay_assignment_actions paa
507: WHERE element_type_id = p_element_type_id
508: AND CREATOR_TYPE = 'RR'

Line 581: FROM pay_element_entries_f peef

577:
578: --Fetching count of Retro employees for the Bug: 14249708
579: SELECT COUNT(DISTINCT(paa.ASSIGNMENT_ID))
580: INTO r_retro_employee_count
581: FROM pay_element_entries_f peef
582: ,per_time_periods ptp
583: ,pay_assignment_actions paa
584: WHERE element_type_id = r_element_type_details.element_type_id
585: AND CREATOR_TYPE = 'RR'