APPS.PQP_GB_TP_CONTRIBUTION_REPORT dependencies on PER_TIME_PERIODS

Line 68: PER_TIME_PERIODS PTP

64: pay_assignment_actions paa ,
65: pay_run_results prr ,
66: pay_run_result_values prrv ,
67: pay_input_values_f pivf ,
68: PER_TIME_PERIODS PTP
69: WHERE ppa.business_group_id = p_business_group_id --Context
70: AND ppa.payroll_id = p_payroll_id --Context
71: AND PTP.PAYROLL_ID = ppa.payroll_id
72: AND PTP.END_DATE = P_DATE_EARNED --CONTEXT

Line 183: PER_TIME_PERIODS PTP

179: pay_assignment_actions paa ,
180: pay_run_results prr ,
181: pay_run_result_values prrv ,
182: pay_input_values_f pivf ,
183: PER_TIME_PERIODS PTP
184: WHERE ppa.business_group_id = p_business_group_id --Context
185: AND ppa.payroll_id = p_payroll_id --Context
186: AND PTP.PAYROLL_ID = ppa.payroll_id
187: AND PTP.END_DATE = P_DATE_EARNED --CONTEXT

Line 299: FROM per_time_periods ptp

295: CURSOR csr_period_details(p_period_id NUMBER) IS
296: SELECT ptp.period_name
297: ,ptp.start_date
298: ,ptp.end_date
299: FROM per_time_periods ptp
300: WHERE ptp.time_period_id = p_period_id;
301: ---------------------
302: CURSOR csr_user_table_details(p_effective_date DATE) IS
303: SELECT max (decode (uc.user_column_name

Line 505: ,per_time_periods ptp

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'
509: AND ptp.TIME_PERIOD_ID = p_time_period_id

Line 582: ,per_time_periods ptp

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'
586: AND ptp.TIME_PERIOD_ID = p_period