[Home] [Help]
118: l_business_group_id pay_payroll_actions.business_group_id%type;
119: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
120: l_effective_date pay_payroll_actions.effective_date%type;
121: l_action_type pay_payroll_actions.action_type%type;
122: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
123: l_assignment_id pay_assignment_actions.assignment_id%type;
124: l_tax_unit_id hr_organization_units.organization_id%type;
125: l_gre_name hr_organization_units.name%type;
126: l_organization_id hr_organization_units.organization_id%type;
119: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
120: l_effective_date pay_payroll_actions.effective_date%type;
121: l_action_type pay_payroll_actions.action_type%type;
122: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
123: l_assignment_id pay_assignment_actions.assignment_id%type;
124: l_tax_unit_id hr_organization_units.organization_id%type;
125: l_gre_name hr_organization_units.name%type;
126: l_organization_id hr_organization_units.organization_id%type;
127: l_org_name hr_organization_units.name%type;
778: l_first_name per_people_f.first_name%type;
779: l_middle_name per_people_f.middle_names%type;
780: l_last_name per_people_f.last_name%type;
781: l_ssn per_people_f.national_identifier%type;
782: l_prev_asg_act_id pay_assignment_actions.assignment_action_id%type;
783: new_asg_act_id pay_assignment_actions.assignment_action_id%type;
784: l_count number := 1;
785: l_bal_id number;
786:
779: l_middle_name per_people_f.middle_names%type;
780: l_last_name per_people_f.last_name%type;
781: l_ssn per_people_f.national_identifier%type;
782: l_prev_asg_act_id pay_assignment_actions.assignment_action_id%type;
783: new_asg_act_id pay_assignment_actions.assignment_action_id%type;
784: l_count number := 1;
785: l_bal_id number;
786:
787:
851: else
852:
853: l_prev_asg_act_id := p_asg_action_id;
854: if (g_inserted_asg_action_id_flag = 'N') then
855: select pay_assignment_actions_s.nextval
856: into new_asg_act_id
857: from dual;
858:
859: -- insert the action record.
1085: l_fed_401k_catchup_limit number;
1086: l_fed_403b_catchup_limit number;
1087: l_fed_457_catchup_limit number;
1088: l_dcp_limit number;
1089: l_prev_asg_act_id pay_assignment_actions.assignment_action_id%type;
1090: new_asg_act_id pay_assignment_actions.assignment_action_id%type;
1091: l_count number := 1;
1092: l_bal_id number;
1093: --
1086: l_fed_403b_catchup_limit number;
1087: l_fed_457_catchup_limit number;
1088: l_dcp_limit number;
1089: l_prev_asg_act_id pay_assignment_actions.assignment_action_id%type;
1090: new_asg_act_id pay_assignment_actions.assignment_action_id%type;
1091: l_count number := 1;
1092: l_bal_id number;
1093: --
1094: --
1317: else
1318:
1319: l_prev_asg_act_id := p_asg_action_id;
1320:
1321: select pay_assignment_actions_s.nextval
1322: into new_asg_act_id
1323: from dual;
1324:
1325: -- insert the action record.
1436: from hr_locations_all hrl,
1437: hr_all_organization_units hou1,
1438: hr_all_organization_units hou,
1439: per_assignments_f paf,
1440: pay_assignment_actions paa, -- PYUGEN
1441: pay_payroll_actions ppa_arch -- PYUGEN
1442: where
1443: -- ppa_arch.payroll_action_id = l_pactid
1444: paa.assignment_action_id = l_aaid
1455: and hou1.organization_id = nvl(paf.organization_id,paf.business_group_id)
1456: and hou.organization_id = paa.tax_unit_id;
1457:
1458: l_bal_date per_assignments_f.effective_end_date%TYPE;
1459: new_asg_act_id pay_assignment_actions.assignment_action_id%type;
1460: --
1461: --
1462: --------------------------- M A I N -------------------------------------
1463: begin
1627: --Bug # 3118107
1628: -----------------------------------------------
1629:
1630: if p_insert_done_flag = 'N' then
1631: select pay_assignment_actions_s.nextval
1632: into new_asg_act_id
1633: from dual;
1634:
1635: --insert the action record