APPS.PAY_DK_ARCHIVE_EHOL dependencies on PER_TIME_PERIODS

Line 333: from per_time_periods ptp

329: ,'Calendar Month','1'
330: ,'Bi-Week' ,'2'
331: ,'Week' ,'3'
332: ,'Lunar Month' ,'4') PAYROLL_PERIOD
333: from per_time_periods ptp
334: WHERE payroll_id = p_payroll_id
335: AND time_period_id = p_payroll_period;
336:
337: rg_csr_pay_periods csr_pay_periods%rowtype;

Line 368: per_time_periods ptp

364: per_assignments_f paf,
365: hr_organization_units hou,
366: hr_organization_information hoi,
367: hr_soft_coding_keyflex scl,
368: per_time_periods ptp
369: WHERE hou.business_group_id = l_business_group_id
370: AND hou.organization_id = g_legal_employer_id
371: AND hou.organization_id = hoi.organization_id
372: AND hoi.org_information_context = 'CLASS'

Line 725: select start_date, end_date from per_time_periods

721: ORDER BY as1.payroll_id, as1.person_id , act.assignment_id;
722:
723: cursor csr_pay_periods(p_payroll_id NUMBER, p_payroll_period NUMBER)
724: is
725: select start_date, end_date from per_time_periods
726: where payroll_id = p_payroll_id
727: and time_period_id = p_payroll_period;
728:
729: pp csr_pay_periods%rowtype;

Line 766: from per_time_periods ptp

762: ,'Calendar Month','1'
763: ,'Bi-Week' ,'2'
764: ,'Week' ,'3'
765: ,'Lunar Month' ,'4') PERIOD_TYPE
766: from per_time_periods ptp
767: WHERE payroll_id = p_payroll_id
768: and rownum=1;
769:
770: l_period_type VARCHAR2(50);

Line 1211: from per_time_periods ptp

1207: ,'Calendar Month','1'
1208: ,'Bi-Week' ,'2'
1209: ,'Week' ,'3'
1210: ,'Lunar Month' ,'4') PAYROLL_PERIOD
1211: from per_time_periods ptp
1212: WHERE payroll_id = p_payroll_id
1213: AND time_period_id = p_payroll_period;
1214:
1215: rg_csr_pay_periods csr_pay_periods%rowtype;

Line 1255: per_time_periods ptp

1251:
1252: FROM
1253: pay_payrolls_f ppf,
1254: per_assignments_f paf,
1255: per_time_periods ptp
1256: WHERE paf.payroll_id = ppf.payroll_id
1257: AND paf.assignment_id=c_assignment_id
1258: AND ppf.payroll_id=NVL(g_payroll_id,ppf.payroll_id)
1259: AND ppf.effective_start_date <= c_canonical_start_date and ppf.effective_end_date >= c_canonical_end_date

Line 1913: per_time_periods ptp

1909: l_select_qry := l_select_str
1910: ||' FROM
1911: pay_payrolls_f ppf,
1912: per_assignments_f paf,
1913: per_time_periods ptp
1914: WHERE paf.payroll_id = ppf.payroll_id
1915: AND paf.assignment_id= ' || l_ass_id
1916: || l_where_clause
1917: ||' AND ppf.effective_start_date <= ' ||''''|| l_canonical_start_date ||''''|| ' and ppf.effective_end_date >= ' ||''''|| l_canonical_end_date ||''''