APPS.PAY_KR_PAYKRYLG_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 716: l_bal_adj_assact pay_assignment_actions.assignment_action_id%type ; -- Bug 4261844

712: is
713: l_yea_info pay_kr_yea_pkg.t_yea_info;
714: l_month number;
715: l_dependent_spouse_count Number; -- 3546994
716: l_bal_adj_assact pay_assignment_actions.assignment_action_id%type ; -- Bug 4261844
717: l_dummy number; -- Bug 10082074
718: --
719: -- Bug 4261844: Get the balance adjustment action (sequenced) from the archival (unsequenced) assact
720: -- p_assignment_action_id...

Line 726: pay_assignment_actions paa,

722: select
723: pai.locked_action_id bal_adj_assact
724: from
725: pay_action_interlocks pai,
726: pay_assignment_actions paa,
727: pay_payroll_actions ppa
728: where
729: pai.locking_action_id = p_assignment_action_id
730: and paa.assignment_action_id = pai.locked_action_id

Line 738: cursor csr_assact(p_bal_adj_assact pay_assignment_actions.assignment_action_id%type)

734: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null)
735: = 'YEA' ;
736: --
737: -- Bug 4261844: ... and use it to get the monthly runs.
738: cursor csr_assact(p_bal_adj_assact pay_assignment_actions.assignment_action_id%type)
739: is
740: select
741: paa2.assignment_action_id,
742: ppa2.effective_date

Line 744: pay_assignment_actions paa2,

740: select
741: paa2.assignment_action_id,
742: ppa2.effective_date
743: from pay_payroll_actions ppa2,
744: pay_assignment_actions paa2,
745: pay_payroll_actions ppa,
746: pay_assignment_actions paa
747: where paa.assignment_action_id = p_bal_adj_assact
748: and ppa.payroll_action_id = paa.payroll_action_id

Line 746: pay_assignment_actions paa

742: ppa2.effective_date
743: from pay_payroll_actions ppa2,
744: pay_assignment_actions paa2,
745: pay_payroll_actions ppa,
746: pay_assignment_actions paa
747: where paa.assignment_action_id = p_bal_adj_assact
748: and ppa.payroll_action_id = paa.payroll_action_id
749: and paa2.assignment_id = paa.assignment_id
750: and paa2.action_sequence < paa.action_sequence

Line 770: pay_assignment_actions paa

766: from per_people_f per,
767: per_periods_of_service pds,
768: per_assignments_f asg,
769: pay_payroll_actions ppa,
770: pay_assignment_actions paa
771: where paa.assignment_action_id = p_assignment_action_id
772: and ppa.payroll_action_id = paa.payroll_action_id
773: and asg.assignment_id = paa.assignment_id
774: and ppa.effective_date