APPS.PAY_CN_AUDIT_XMLGEN dependencies on PER_TIME_PERIODS

Line 471: FROM per_time_periods ptp,

467: SELECT to_char(ptp.period_num) pno,
468: to_CHAR(ptp.start_date,'YYYYMMDD') strt,
469: to_CHAR(ptp.end_date,'YYYYMMDD') ende,
470: to_CHAR(ptp.regular_payment_date,'YYYY') yr
471: FROM per_time_periods ptp,
472: pay_payrolls_f ppf
473: WHERE ptp.payroll_id = ppf.payroll_id
474: AND decode(g_trfr_date_used,'E',ptp.end_date,ptp.regular_payment_date) BETWEEN g_start_date and g_end_date
475: AND EXISTS(SELECT 1