DBA Data[Home] [Help]

APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on PER_TIME_PERIODS

Line 1176: ,per_time_periods ptp

1172: FROM pay_assignment_actions paa
1173: ,pay_payroll_actions ppa
1174: ,hr_lookups hrl
1175: ,pay_action_information pai
1176: ,per_time_periods ptp
1177: WHERE /* paa.assignment_id = c_assignment_id */
1178: ppa.effective_Date BETWEEN c_start_date
1179: AND c_end_date
1180: AND ppa.report_type = hrl.meaning

Line 1222: ,per_time_periods ptp

1218: ,pay_payroll_actions ppa
1219: ,hr_lookups hrl
1220: ,hr_assignment_set_amendments hasa
1221: ,pay_action_information pai
1222: ,per_time_periods ptp
1223: WHERE ppa.effective_Date BETWEEN c_start_date
1224: AND c_end_date
1225: AND ppa.report_type = hrl.meaning
1226: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'