APPS.PAY_ZA_COIDA_ARCHIVE dependencies on PER_TIME_PERIODS

Line 219: FROM per_time_periods ptp

215:
216: -- Retrieve the report start and end dates
217: SELECT ptp.start_date
218: INTO g_start_period_date
219: FROM per_time_periods ptp
220: WHERE ptp.time_period_id = l_strt_prd_id;
221:
222: SELECT ptp.end_date
223: INTO g_end_period_date

Line 224: FROM per_time_periods ptp

220: WHERE ptp.time_period_id = l_strt_prd_id;
221:
222: SELECT ptp.end_date
223: INTO g_end_period_date
224: FROM per_time_periods ptp
225: WHERE ptp.time_period_id = l_end_prd_id;
226:
227: --Retrieve Organization and Payroll name
228: Begin

Line 298: from per_time_periods

294: -- Get the number of days in the tax year
295: begin
296: select max(end_date) - min(start_date) + 1
297: into g_num_of_days
298: from per_time_periods
299: where payroll_id = l_payroll_id
300: and prd_information1 = (select prd_information1
301: from per_time_periods
302: where payroll_id = l_payroll_id

Line 301: from per_time_periods

297: into g_num_of_days
298: from per_time_periods
299: where payroll_id = l_payroll_id
300: and prd_information1 = (select prd_information1
301: from per_time_periods
302: where payroll_id = l_payroll_id
303: and g_start_period_date between start_date and end_date);
304: end;
305:

Line 710: per_time_periods ptp

706: select max(paa.action_sequence)
707: into l_run_action_seq
708: from pay_assignment_actions paa,
709: pay_payroll_actions ppa,
710: per_time_periods ptp
711: where paa.assignment_id = p_asg_id
712: and paa.action_status IN ('C','S') --10376999
713: and paa.payroll_action_id = ppa.payroll_action_id
714: and ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')

Line 744: from per_time_periods ptp

740: select min(ptp.start_date),
741: max(ptp.end_date)
742: into l_start_date,
743: l_end_date
744: from per_time_periods ptp
745: where ptp.payroll_id = P_PAYROLL_ID
746: and ptp.pay_advice_date <= P_DATE
747: and ptp.pay_advice_date >= L_START_PY_ADV_DT;
748:

Line 859: from per_time_periods

855: begin
856: hr_utility.set_location('getting max(PAY_ADVICE_DATE)+1 ',20);
857: select max(PAY_ADVICE_DATE)+1
858: into l_pay_adv_start_date
859: from per_time_periods
860: where payroll_id=p_payroll_id
861: and PAY_ADVICE_DATE < l_start_py_adv_dt;
862:
863: hr_utility.set_location('l_pay_adv_start_date '|| l_pay_adv_start_date || ' :',30);

Line 1016: from per_time_periods

1012:
1013: cursor csr_pay_dates(p_payroll_id number)
1014: is
1015: select distinct pay_advice_date
1016: from per_time_periods
1017: where payroll_id=p_payroll_id
1018: and start_date >=g_start_period_date
1019: and end_date <= g_end_period_date
1020: order by pay_advice_date;

Line 1150: from per_time_periods

1146: loop
1147: begin
1148: select max(PAY_ADVICE_DATE)+1
1149: into l_pay_adv_start_date
1150: from per_time_periods
1151: where payroll_id=l_payroll_id
1152: and PAY_ADVICE_DATE < rec_pay_dates.pay_advice_date;
1153: hr_utility.set_location('l_pay_adv_start_date:'||to_char(l_pay_adv_start_date,'dd-mm-yyyy'),20);
1154: l_pay_adv_start_date := nvl(l_pay_adv_start_date,trunc(rec_pay_dates.pay_advice_date,'MM')); -- Bug 12572065

Line 1287: from per_time_periods

1283:
1284: --Retrieve all months till period end date which donot have the ZA_COID_TOT_MONTH_INFO
1285: cursor csr_zero_totals (p_payroll_id number, p_strt_prd_id number, p_end_prd_id number, p_asg_type varchar2) is
1286: select to_char(PAY_ADVICE_DATE,'MON') mon -- Modified
1287: from per_time_periods
1288: where payroll_id = p_payroll_id
1289: and time_period_id >= p_strt_prd_id
1290: and time_period_id <= p_end_prd_id
1291: minus