APPS.PAY_DK_RULES dependencies on PAY_PAYROLL_ACTIONS

Line 62: FROM pay_payroll_actions ppa, pay_assignment_actions paa

58:
59: /* Added cursor to fetch effective date */
60: CURSOR c_effective_date(p_asg_act_id NUMBER ) IS
61: SELECT effective_date
62: FROM pay_payroll_actions ppa, pay_assignment_actions paa
63: WHERE paa.assignment_action_id = p_asg_act_id
64: AND paa.payroll_action_id = ppa.payroll_action_id ;
65:
66:

Line 685: leg_param pay_payroll_actions.legislative_parameters%TYPE;

681: /* 10156538 start */
682: procedure archinit(p_payroll_action_id in number) is
683:
684: l_payroll_id NUMBER;
685: leg_param pay_payroll_actions.legislative_parameters%TYPE;
686: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
687: l_key varchar2(30) := 'PAYROLL_ID=';
688: l_val pay_payroll_actions.legislative_parameters%TYPE;
689:

Line 686: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;

682: procedure archinit(p_payroll_action_id in number) is
683:
684: l_payroll_id NUMBER;
685: leg_param pay_payroll_actions.legislative_parameters%TYPE;
686: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
687: l_key varchar2(30) := 'PAYROLL_ID=';
688: l_val pay_payroll_actions.legislative_parameters%TYPE;
689:
690:

Line 688: l_val pay_payroll_actions.legislative_parameters%TYPE;

684: l_payroll_id NUMBER;
685: leg_param pay_payroll_actions.legislative_parameters%TYPE;
686: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
687: l_key varchar2(30) := 'PAYROLL_ID=';
688: l_val pay_payroll_actions.legislative_parameters%TYPE;
689:
690:
691: begin
692:

Line 698: FROM pay_payroll_actions

694: hr_utility.set_location('Entering procedure archinit' , 1);
695:
696: SELECT legislative_parameters,payroll_id
697: INTO leg_param,l_ppa_payroll_id
698: FROM pay_payroll_actions
699: WHERE payroll_action_id = p_payroll_action_id ;
700:
701:
702: if instr(leg_param, l_key) <> 0 then

Line 715: UPDATE pay_payroll_actions

711: -- Update the Payroll Action with the Payroll ID
712: hr_utility.set_location('l_payroll_id'|| l_payroll_id , 2);
713: IF l_ppa_payroll_id IS NULL and l_payroll_id is not NULL THEN
714:
715: UPDATE pay_payroll_actions
716: SET payroll_id = l_payroll_id
717: WHERE payroll_action_id = p_payroll_action_id;
718: hr_utility.set_location('After Update', 2);
719: