APPS.PAY_NO_K27_REIM_UPLD dependencies on PER_TIME_PERIODS

Line 104: per_time_periods ptp

100: select distinct ptp.start_date
101: from
102: per_all_assignments_f paaf,
103: pay_payrolls_f ppf,
104: per_time_periods ptp
105: where
106: paaf.assignment_id = p_assignment_id
107: AND paaf.business_group_id = p_business_group_id
108: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 506: from per_time_periods ptp

502: and ppa.action_status = 'C'
503: and ppa.payroll_id = p_payroll_id
504: and exists
505: (select 1
506: from per_time_periods ptp
507: where
508: ptp.payroll_id = ppa.payroll_id
509: and ptp.time_period_id = ppa.time_period_id
510: and p_period_date BETWEEN ptp.start_date AND ptp.end_date

Line 1036: from per_time_periods ptp

1032: ,'Calendar Month','1'
1033: ,'Bi-Week' ,'2'
1034: ,'Week' ,'3'
1035: ,'Lunar Month' ,'4') PAYROLL_PERIOD
1036: from per_time_periods ptp
1037: WHERE payroll_id = p_payroll_id
1038: AND time_period_id = p_payroll_period;
1039:
1040: rg_csr_pay_periods csr_pay_periods%rowtype;

Line 1071: per_time_periods ptp

1067: per_assignments_f paf,
1068: hr_organization_units hou,
1069: hr_organization_information hoi,
1070: hr_soft_coding_keyflex scl,
1071: per_time_periods ptp
1072: WHERE hou.business_group_id = l_business_group_id
1073: AND hou.organization_id = g_legal_employer_id
1074: AND hou.organization_id = hoi.organization_id
1075: AND hoi.org_information_context = 'CLASS'