APPS.PAY_DK_ARCHIVE_EIN dependencies on PER_TIME_PERIODS

Line 265: from per_time_periods ptp

261: ,'Calendar Month','1'
262: ,'Bi-Week' ,'2'
263: ,'Week' ,'3'
264: ,'Lunar Month' ,'4') PAYROLL_PERIOD
265: from per_time_periods ptp
266: WHERE payroll_id = p_payroll_id
267: AND time_period_id = p_payroll_period;
268:
269: rg_csr_pay_periods csr_pay_periods%rowtype;

Line 300: per_time_periods ptp

296: per_assignments_f paf,
297: hr_organization_units hou,
298: hr_organization_information hoi,
299: hr_soft_coding_keyflex scl,
300: per_time_periods ptp
301: WHERE hou.business_group_id = l_business_group_id
302: AND hou.organization_id = g_legal_employer_id
303: AND hou.organization_id = hoi.organization_id
304: AND hoi.org_information_context = 'CLASS'

Line 747: select start_date, end_date from per_time_periods

743: ORDER BY as1.person_id , act.assignment_id;
744:
745: cursor csr_pay_periods(p_payroll_id NUMBER, p_payroll_period NUMBER)
746: is
747: select start_date, end_date from per_time_periods
748: where payroll_id = p_payroll_id
749: and time_period_id = p_payroll_period;
750:
751: pp csr_pay_periods%rowtype;

Line 954: from per_time_periods ptp

950: ,'Calendar Month','1'
951: ,'Bi-Week' ,'2'
952: ,'Week' ,'3'
953: ,'Lunar Month' ,'4') PAYROLL_PERIOD
954: from per_time_periods ptp
955: WHERE payroll_id = p_payroll_id
956: AND time_period_id = p_payroll_period;
957:
958: rg_csr_pay_periods csr_pay_periods%rowtype;

Line 997: per_time_periods ptp

993:
994: FROM
995: pay_payrolls_f ppf,
996: per_assignments_f paf,
997: per_time_periods ptp
998: WHERE paf.payroll_id = ppf.payroll_id
999: AND paf.assignment_id=c_assignment_id
1000: AND ppf.payroll_id=NVL(g_payroll_id,ppf.payroll_id)
1001: AND ppf.effective_start_date <= c_canonical_start_date and ppf.effective_end_date >= c_canonical_end_date