APPS.PAY_CA_YEER_PKG dependencies on PER_TIME_PERIODS

Line 2924: from per_time_periods target

2920: /* The cursor cur_rl_cpp_periods retrives the QPP periods for an Employee. */
2921:
2922: cursor cur_rl_cpp_periods ( cp_payroll_id in number ) is
2923: select count(regular_payment_date)
2924: from per_time_periods target
2925: where payroll_id = cp_payroll_id
2926: and to_char( target.regular_payment_date,'YYYY' ) = sv_reporting_year;
2927:
2928: /* The cursor cur_rl_asg_act retrieves all assignment action ids for input

Line 3374: from per_time_periods target

3370: /* The cursor cur_cpp_periods retrives the CPP periods for an Employee. */
3371:
3372: cursor cur_cpp_periods ( cp_payroll_id in number ) is
3373: select count(regular_payment_date)
3374: from per_time_periods target
3375: where payroll_id = cp_payroll_id
3376: and to_char( target.regular_payment_date,'YYYY' ) = sv_reporting_year;
3377:
3378: /* The cursor cur_asg_act retrieves all assignment action ids for input