APPS.PAY_CA_WF_PKG dependencies on PER_TIME_PERIODS

Line 810: from per_time_periods

806: where parameter_name = 'PAYROLL_CA_WF_NOTIFY_ACTION';
807:
808: cursor cur_retro_period is
809: select period_name
810: from per_time_periods
811: where payroll_id = l_payroll_id
812: and end_date = fnd_date.canonical_to_date(p_date_earned);
813:
814: cursor cur_event_group is

Line 1318: from per_time_periods

1314:
1315: begin
1316: select period_name
1317: into lv_gtn_period
1318: from per_time_periods
1319: where payroll_id = to_number(p_payroll_id)
1320: and time_period_id = to_number(p_gross_to_net_period);
1321:
1322: hr_utility.trace('lv_gtn_period = ' || lv_gtn_period);

Line 2931: from per_time_periods

2927: where parameter_name = 'PAYROLL_CA_WF_NOTIFY_ACTION';
2928:
2929: cursor cur_retro_period is
2930: select period_name
2931: from per_time_periods
2932: where payroll_id = l_payroll_id
2933: and end_date = fnd_date.canonical_to_date(p_date_earned);
2934:
2935: cursor cur_event_group is

Line 3454: from per_time_periods

3450:
3451: begin
3452: select period_name
3453: into lv_gtn_period
3454: from per_time_periods
3455: where payroll_id = to_number(p_payroll_id)
3456: and time_period_id = to_number(p_gross_to_net_period);
3457:
3458: hr_utility.trace('lv_gtn_period = ' || lv_gtn_period);