APPS.PAY_CA_YEER_PKG dependencies on PER_TIME_PERIODS

Line 3291: from per_time_periods target

3287: /* The cursor cur_rl_cpp_periods retrives the QPP periods for an Employee. */
3288:
3289: cursor cur_rl_cpp_periods ( cp_payroll_id in number ) is
3290: select count(regular_payment_date)
3291: from per_time_periods target
3292: where payroll_id = cp_payroll_id
3293: and to_char( target.regular_payment_date,'YYYY' ) = sv_reporting_year;
3294:
3295: /* The cursor cur_rl_asg_act retrieves all assignment action ids for input

Line 3837: from per_time_periods target

3833: /* The cursor cur_cpp_periods retrives the CPP periods for an Employee. */
3834:
3835: cursor cur_cpp_periods ( cp_payroll_id in number ) is
3836: select count(regular_payment_date)
3837: from per_time_periods target
3838: where payroll_id = cp_payroll_id
3839: and to_char( target.regular_payment_date,'YYYY' ) = sv_reporting_year;
3840:
3841: /* The cursor cur_asg_act retrieves all assignment action ids for input