[Home] [Help]
544:
545:
546: CURSOR c_term_date_decode(c_term_date IN DATE) IS
547: SELECT decode(c_term_date,to_date('31-12-4712','dd-mm-yyyy'),null,c_term_date)
548: FROM DUAL;
549:
550:
551: CURSOR
552: c_no_of_days(c_end_date IN DATE, c_start_date IN DATE)
551: CURSOR
552: c_no_of_days(c_end_date IN DATE, c_start_date IN DATE)
553: IS
554: SELECT (c_end_date - c_start_date + 1)
555: FROM DUAL;
556:
557: CURSOR
558: c_get_average_days_per_month(c_assignment_id IN NUMBER,
559: c_effective_date IN DATE
3397: AND business_group_id = p_business_group_id;
3398:
3399: --Cursor to chk if the organization has any overridden pension types attached
3400: CURSOR c_is_any_pt_assigned(c_org_id in number) IS
3401: select 1 from dual
3402: where exists (select 1 from hr_organization_information
3403: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3404: AND organization_id = c_org_id
3405: AND p_date_earned between fnd_date.canonical_to_date(org_information4)
4576: AND pbd.legislation_code = 'NL';
4577:
4578: CURSOR c_get_prev_run_year(c_date_earned IN DATE) IS
4579: SELECT TO_NUMBER(TO_CHAR(c_date_earned,'YYYY')) -1
4580: FROM dual;
4581:
4582: CURSOR c_get_payroll_id(c_effective_date IN DATE) IS
4583: SELECT payroll_id
4584: FROM per_all_assignments_f