DBA Data[Home] [Help]

APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on PER_TIME_PERIODS

Line 1166: ,per_time_periods ptp

1162: FROM pay_assignment_actions paa
1163: ,pay_payroll_actions ppa
1164: ,hr_lookups hrl
1165: ,pay_action_information pai
1166: ,per_time_periods ptp
1167: WHERE /* paa.assignment_id = c_assignment_id */
1168: ppa.effective_Date BETWEEN c_start_date
1169: AND c_end_date
1170: AND ppa.report_type = hrl.meaning

Line 1212: ,per_time_periods ptp

1208: ,pay_payroll_actions ppa
1209: ,hr_lookups hrl
1210: ,hr_assignment_set_amendments hasa
1211: ,pay_action_information pai
1212: ,per_time_periods ptp
1213: WHERE ppa.effective_Date BETWEEN c_start_date
1214: AND c_end_date
1215: AND ppa.report_type = hrl.meaning
1216: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'