[Home] [Help]
502:
503:
504: CURSOR c_term_date_decode(c_term_date IN DATE) IS
505: SELECT decode(c_term_date,to_date('31-12-4712','dd-mm-yyyy'),null,c_term_date)
506: FROM DUAL;
507:
508:
509: CURSOR
510: c_no_of_days(c_end_date IN DATE, c_start_date IN DATE)
509: CURSOR
510: c_no_of_days(c_end_date IN DATE, c_start_date IN DATE)
511: IS
512: SELECT (c_end_date - c_start_date + 1)
513: FROM DUAL;
514:
515: CURSOR
516: c_get_average_days_per_month(c_assignment_id IN NUMBER,
517: c_effective_date IN DATE
3300: AND business_group_id = p_business_group_id;
3301:
3302: --Cursor to chk if the organization has any overridden pension types attached
3303: CURSOR c_is_any_pt_assigned(c_org_id in number) IS
3304: select 1 from dual
3305: where exists (select 1 from hr_organization_information
3306: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3307: AND organization_id = c_org_id
3308: AND p_date_earned between fnd_date.canonical_to_date(org_information4)
4479: AND pbd.legislation_code = 'NL';
4480:
4481: CURSOR c_get_prev_run_year(c_date_earned IN DATE) IS
4482: SELECT TO_NUMBER(TO_CHAR(c_date_earned,'YYYY')) -1
4483: FROM dual;
4484:
4485: CURSOR c_get_payroll_id(c_effective_date IN DATE) IS
4486: SELECT payroll_id
4487: FROM per_all_assignments_f