APPS.PAY_CA_WF_PKG dependencies on PER_TIME_PERIODS

Line 532: from per_time_periods

528: where parameter_name = 'PAYROLL_CA_WF_NOTIFY_ACTION';
529:
530: cursor cur_retro_period is
531: select period_name
532: from per_time_periods
533: where payroll_id = l_payroll_id
534: and end_date = fnd_date.canonical_to_date(p_date_earned);
535:
536: cursor cur_event_group is

Line 1040: from per_time_periods

1036:
1037: begin
1038: select period_name
1039: into lv_gtn_period
1040: from per_time_periods
1041: where payroll_id = to_number(p_payroll_id)
1042: and time_period_id = to_number(p_gross_to_net_period);
1043:
1044: hr_utility.trace('lv_gtn_period = ' || lv_gtn_period);