[Home] [Help]
198: '0', null,
199: instr(LEGISLATIVE_PARAMETERS,'EXPIRATION_DATE='))+16,11),
200: to_char(add_months(sysdate,2),'YYYY/MM/DD HH24:MI:SS') ) Expiration_date
201: into p_expiration_date
202: from pay_payroll_actions
203: where PAYROLL_ACTION_ID = p_payroll_action_id;
204: --
205: RETURN p_expiration_date;
206: --
217: '0', null,
218: instr(LEGISLATIVE_PARAMETERS,'SUBMISSION_NUMBER='))+18,6),
219: 'NOLABL') Submission_number
220: into p_submission_number
221: from pay_payroll_actions
222: where PAYROLL_ACTION_ID = p_payroll_action_id;
223: --
224: hr_utility.set_location('bacsmgtp.get_submission_number',2);
225: RETURN p_submission_number;
236: BEGIN
237: select
238: to_char(OVERRIDING_DD_DATE ,'YYYY/MM/DD HH24:MI:SS') effdate
239: into p_process_date
240: from pay_payroll_actions
241: where PAYROLL_ACTION_ID = p_payroll_action_id;
242: --
243: EXCEPTION when others then
244: hr_utility.set_message(801, 'Other error in get_process_date f');
569: --
570: CURSOR csr_get_default_date IS
571: select default_dd_date
572: from pay_assignment_actions paa,
573: pay_payroll_actions ppa,
574: per_time_periods ptp
575: where paa.assignment_action_id =
576: p_assignment_action_id
577: and ppa.payroll_action_id =
584: decode(tpr.basic_period_type,'CM',tpr.periods_per_period,0)
585: from per_time_period_rules tpr,
586: per_time_period_types tpt,
587: per_time_periods ptp,
588: pay_payroll_actions ppa,
589: pay_assignment_actions paa
590: where paa.assignment_action_id = p_assignment_action_id
591: and ppa.payroll_action_id = paa.payroll_action_id
592: and ptp.time_period_id = ppa.time_period_id
641: return date is
642: --
643: CURSOR csr_get_details is
644: select paa.assignment_id, ppa.effective_date
645: from pay_payroll_actions ppa,
646: pay_assignment_actions paa
647: where paa.assignment_action_id = p_assignment_action_id
648: and ppa.payroll_action_id = paa.payroll_action_id;
649: --