APPS.PAY_DK_ARCHIVE_EIN dependencies on PER_TIME_PERIODS

Line 207: from per_time_periods ptp

203: ,'Calendar Month','1'
204: ,'Bi-Week' ,'2'
205: ,'Week' ,'3'
206: ,'Lunar Month' ,'4') PAYROLL_PERIOD
207: from per_time_periods ptp
208: WHERE payroll_id = p_payroll_id
209: AND time_period_id = p_payroll_period;
210:
211: rg_csr_pay_periods csr_pay_periods%rowtype;

Line 631: select start_date, end_date from per_time_periods

627: ORDER BY as1.person_id , act.assignment_id;
628:
629: cursor csr_pay_periods(p_payroll_id NUMBER, p_payroll_period NUMBER)
630: is
631: select start_date, end_date from per_time_periods
632: where payroll_id = p_payroll_id
633: and time_period_id = p_payroll_period;
634:
635: pp csr_pay_periods%rowtype;

Line 795: from per_time_periods ptp

791: ,'Calendar Month','1'
792: ,'Bi-Week' ,'2'
793: ,'Week' ,'3'
794: ,'Lunar Month' ,'4') PAYROLL_PERIOD
795: from per_time_periods ptp
796: WHERE payroll_id = p_payroll_id
797: AND time_period_id = p_payroll_period;
798:
799: rg_csr_pay_periods csr_pay_periods%rowtype;