[Home] [Help]
411: is
412: l_yea_info pay_kr_yea_pkg.t_yea_info;
413: l_month number;
414: l_dependent_spouse_count Number; -- 3546994
415: l_bal_adj_assact pay_assignment_actions.assignment_action_id%type ; -- Bug 4261844
416: --
417: -- Bug 4261844: Get the balance adjustment action (sequenced) from the archival (unsequenced) assact
418: -- p_assignment_action_id...
419: cursor csr_bal_adj_assact is
420: select
421: pai.locked_action_id bal_adj_assact
422: from
423: pay_action_interlocks pai,
424: pay_assignment_actions paa,
425: pay_payroll_actions ppa
426: where
427: pai.locking_action_id = p_assignment_action_id
428: and paa.assignment_action_id = pai.locked_action_id
432: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null)
433: = 'YEA' ;
434: --
435: -- Bug 4261844: ... and use it to get the monthly runs.
436: cursor csr_assact(p_bal_adj_assact pay_assignment_actions.assignment_action_id%type)
437: is
438: select
439: paa2.assignment_action_id,
440: ppa2.effective_date
438: select
439: paa2.assignment_action_id,
440: ppa2.effective_date
441: from pay_payroll_actions ppa2,
442: pay_assignment_actions paa2,
443: pay_payroll_actions ppa,
444: pay_assignment_actions paa
445: where paa.assignment_action_id = p_bal_adj_assact
446: and ppa.payroll_action_id = paa.payroll_action_id
440: ppa2.effective_date
441: from pay_payroll_actions ppa2,
442: pay_assignment_actions paa2,
443: pay_payroll_actions ppa,
444: pay_assignment_actions paa
445: where paa.assignment_action_id = p_bal_adj_assact
446: and ppa.payroll_action_id = paa.payroll_action_id
447: and paa2.assignment_id = paa.assignment_id
448: and paa2.action_sequence < paa.action_sequence