APPS.PAY_RUN_BALANCE_BUILD dependencies on PAY_ASSIGNMENT_ACTIONS

Line 518: from pay_assignment_actions paa,

514: ppa.effective_date,
515: nvl(prt.run_method, 'N') run_method,
516: ppa.business_group_id,
517: pbg.legislation_code
518: from pay_assignment_actions paa,
519: pay_payroll_actions ppa,
520: pay_run_types_f prt,
521: per_business_groups_perf pbg
522: where paa.assignment_id = p_assid

Line 1015: from pay_assignment_actions paa,

1011: select paa.assignment_action_id,
1012: ppa.effective_date,
1013: nvl(prt.run_method, 'N') run_method,
1014: ppa.business_group_id
1015: from pay_assignment_actions paa,
1016: pay_payroll_actions ppa,
1017: pay_run_types_f prt,
1018: pay_assignment_actions paa_arch
1019: where paa_arch.assignment_action_id = p_assactid

Line 1018: pay_assignment_actions paa_arch

1014: ppa.business_group_id
1015: from pay_assignment_actions paa,
1016: pay_payroll_actions ppa,
1017: pay_run_types_f prt,
1018: pay_assignment_actions paa_arch
1019: where paa_arch.assignment_action_id = p_assactid
1020: and paa_arch.assignment_id = paa.assignment_id
1021: and paa.payroll_action_id = ppa.payroll_action_id
1022: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')

Line 1035: l_asg_id pay_assignment_actions.assignment_id%type;

1031: l_object_id number;
1032: l_delete_bals boolean;
1033: l_grp_eff_date date;
1034: l_bus_grp pay_payroll_actions.business_group_id%type;
1035: l_asg_id pay_assignment_actions.assignment_id%type;
1036: --
1037: BEGIN
1038: hr_utility.set_location(
1039: 'Entering:pay_run_balance_build.action_archive_data',10);

Line 1046: from pay_assignment_actions paa,

1042: paa.object_id,
1043: paa.assignment_id,
1044: ppa.business_group_id
1045: into l_payroll_action_id, l_object_id, l_asg_id, l_bus_grp
1046: from pay_assignment_actions paa,
1047: pay_payroll_actions ppa
1048: where paa.assignment_action_id = p_assactid
1049: and ppa.payroll_action_id = paa.payroll_action_id;
1050: --

Line 1402: select pay_assignment_actions_s.nextval

1398: p_end_person_id,
1399: p_payroll_action_id
1400: ) loop
1401: --
1402: select pay_assignment_actions_s.nextval
1403: into ln_lockingactid
1404: from dual;
1405: --
1406: -- insert into pay_assignment_actions.

Line 1406: -- insert into pay_assignment_actions.

1402: select pay_assignment_actions_s.nextval
1403: into ln_lockingactid
1404: from dual;
1405: --
1406: -- insert into pay_assignment_actions.
1407: hr_nonrun_asact.insact(ln_lockingactid,
1408: -1,
1409: p_payroll_action_id,
1410: p_chunk,

Line 1425: select pay_assignment_actions_s.nextval

1421: p_end_person_id,
1422: p_payroll_action_id
1423: ) loop
1424: --
1425: select pay_assignment_actions_s.nextval
1426: into ln_lockingactid
1427: from dual;
1428: --
1429: -- insert into pay_assignment_actions.

Line 1429: -- insert into pay_assignment_actions.

1425: select pay_assignment_actions_s.nextval
1426: into ln_lockingactid
1427: from dual;
1428: --
1429: -- insert into pay_assignment_actions.
1430: hr_nonrun_asact.insact(ln_lockingactid,
1431: aarec.assignment_id,
1432: p_payroll_action_id,
1433: p_chunk,

Line 1550: from pay_assignment_actions

1546: --
1547: /* Remove the actions if needed */
1548: select count(*)
1549: into act_com
1550: from pay_assignment_actions
1551: where payroll_action_id = pactid
1552: and action_status <> 'C';
1553: --
1554: if act_com = 0 then