eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_RUN_BALANCE_BUILD dependencies on PAY_PAYROLL_ACTIONS

Line 23: g_generate_pact pay_payroll_actions.payroll_action_id%type;

19: g_att_cached boolean; /*Bug 9315998*/
20: g_debug boolean := hr_utility.debug_enabled;
21: g_purge_only boolean default FALSE;
22: g_program_name fnd_concurrent_programs.concurrent_program_name%type;
23: g_generate_pact pay_payroll_actions.payroll_action_id%type;
24:
25: Type typ_def_bal is table of pay_defined_balances.defined_balance_id%type index by binary_integer;
26: g_tab_def_bal typ_def_bal;
27:

Line 116: from pay_payroll_actions ppa,

112: nvl(pay_core_utils.get_parameter('BAL_LVL',
113: ppa.legislative_parameters),
114: 'BOTH') balance_level,
115: pbd.dimension_level
116: from pay_payroll_actions ppa,
117: per_business_groups pbg,
118: pay_defined_balances pdb,
119: pay_balance_dimensions pbd
120: where ppa.payroll_action_id = p_pact_id

Line 146: l_bus_grp pay_payroll_actions.business_group_id%type;

142: = 'BOTH')
143: );
144: --
145: l_run_bal_stat pay_balance_validation.run_balance_status%type;
146: l_bus_grp pay_payroll_actions.business_group_id%type;
147: l_request_id fnd_concurrent_requests.request_id%type;
148: l_old_balance_load_date pay_balance_validation.balance_load_date%type;
149: --
150: begin

Line 155: from pay_payroll_actions

151: g_purge_only := FALSE;
152: --
153: select business_group_id, request_id
154: into l_bus_grp, l_request_id
155: from pay_payroll_actions
156: where payroll_action_id = p_pactid;
157:
158: -- bug 14301014 mark non run balances as invalid
159: update pay_balance_validation bv

Line 262: update pay_payroll_actions set legislative_parameters = legislative_parameters || ' PURGE_ONLY=Y'

258: and pbv.business_group_id (+) = l_bus_grp;
259:
260: if g_program_name = 'RB_ADJD' and l_old_balance_load_date <= g_start_date and l_run_bal_stat = 'V' then
261: g_purge_only := TRUE;
262: update pay_payroll_actions set legislative_parameters = legislative_parameters || ' PURGE_ONLY=Y'
263: where payroll_action_id = p_pactid
264: and legislative_parameters not like '%PURGE_ONLY%';
265: if g_debug then
266: hr_utility.trace('set_run_bal_status g_purge_only. l_old_balance_load_date:'||

Line 333: from pay_payroll_actions pa1,

329: g_leg_code,
330: g_bus_grp,
331: g_att_name,
332: g_generate_pact
333: from pay_payroll_actions pa1,
334: per_business_groups pbg
335: where pa1.payroll_action_id = p_pact_id
336: and pa1.business_group_id = pbg.business_group_id;
337: --

Line 614: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)

610: --
611: cursor getaa (p_assid in number, p_bal_load_date in date
612: ) is
613: select /*+ ORDERED USE_NL(ppa prt)
614: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
615: INDEX(prt PAY_RUN_TYPES_PK) */
616: paa.assignment_action_id,
617: ppa.effective_date,
618: nvl(prt.run_method, 'N') run_method,

Line 621: pay_payroll_actions ppa,

617: ppa.effective_date,
618: nvl(prt.run_method, 'N') run_method,
619: ppa.business_group_id
620: from pay_assignment_actions paa,
621: pay_payroll_actions ppa,
622: pay_run_types_f prt
623: where paa.assignment_id = p_assid
624: and paa.assignment_action_id in
625: ( select assignment_action_id from pay_assignment_actions where assignment_id = p_assid

Line 1084: l_bus_grp pay_payroll_actions.business_group_id%type;

1080:
1081: procedure process_group_lvl_balances( p_pactid in number)
1082: is
1083: l_grp_eff_date date;
1084: l_bus_grp pay_payroll_actions.business_group_id%type;
1085: l_run_bal_status pay_balance_validation.run_balance_status%type;
1086: l_bal_load_date pay_balance_validation.balance_load_date%type;
1087: l_leg_code per_business_groups.legislation_code%type;
1088: l_del_cnt number;

Line 1101: from pay_payroll_actions ppa,

1097: pbg.legislation_code
1098: into l_grp_eff_date,
1099: l_bus_grp,
1100: l_leg_code
1101: from pay_payroll_actions ppa,
1102: per_business_groups pbg
1103: where ppa.payroll_action_id = p_pactid
1104: and ppa.business_group_id = pbg.business_group_id;
1105: exception

Line 1259: pay_payroll_actions ppa,

1255: ppa.effective_date,
1256: nvl(prt.run_method, 'N') run_method,
1257: ppa.business_group_id
1258: from pay_assignment_actions paa,
1259: pay_payroll_actions ppa,
1260: pay_run_types_f prt,
1261: pay_assignment_actions paa_arch
1262: where paa_arch.assignment_action_id = p_assactid
1263: and paa_arch.assignment_id = paa.assignment_id

Line 1277: l_bus_grp pay_payroll_actions.business_group_id%type;

1273: l_payroll_action_id number;
1274: l_object_id number;
1275: l_delete_bals boolean;
1276: l_grp_eff_date date;
1277: l_bus_grp pay_payroll_actions.business_group_id%type;
1278: l_asg_id pay_assignment_actions.assignment_id%type;
1279: l_chunk_number pay_assignment_actions.chunk_number%type;
1280: --
1281: BEGIN

Line 1292: pay_payroll_actions ppa

1288: paa.chunk_number,
1289: ppa.business_group_id
1290: into l_payroll_action_id, l_object_id, l_asg_id, l_chunk_number, l_bus_grp
1291: from pay_assignment_actions paa,
1292: pay_payroll_actions ppa
1293: where paa.assignment_action_id = p_assactid
1294: and ppa.payroll_action_id = paa.payroll_action_id;
1295: --
1296: set_globals(l_payroll_action_id);

Line 1602: from pay_payroll_actions ppa,

1598: if (g_bal_lvl = 'GRP') then
1599: if (g_save_run_bals = 'Y') then
1600: lv_sql_string :=
1601: 'select ppa_r.payroll_action_id
1602: from pay_payroll_actions ppa,
1603: pay_payroll_actions ppa_r
1604: where ppa.payroll_action_id = :payroll_action_id
1605: and ppa_r.action_type in (''R'',''Q'',''B'', ''I'',''V'')
1606: and ppa.business_group_id = ppa_r.business_group_id

Line 1603: pay_payroll_actions ppa_r

1599: if (g_save_run_bals = 'Y') then
1600: lv_sql_string :=
1601: 'select ppa_r.payroll_action_id
1602: from pay_payroll_actions ppa,
1603: pay_payroll_actions ppa_r
1604: where ppa.payroll_action_id = :payroll_action_id
1605: and ppa_r.action_type in (''R'',''Q'',''B'', ''I'',''V'')
1606: and ppa.business_group_id = ppa_r.business_group_id
1607: order by ppa_r.payroll_action_id';

Line 1616: pay_payroll_actions ppa

1612: 'select distinct asg.person_id
1613: from
1614: per_periods_of_service pos,
1615: per_assignments_f asg,
1616: pay_payroll_actions ppa
1617: where ppa.payroll_action_id = :payroll_action_id
1618: and pos.person_id = asg.person_id
1619: and pos.period_of_service_id = asg.period_of_service_id
1620: and pos.business_group_id = ppa.business_group_id

Line 1656: from pay_payroll_actions ppa,

1652: enpactid in number,
1653: pact_id in number
1654: ) is
1655: select ppa.payroll_action_id
1656: from pay_payroll_actions ppa,
1657: pay_payroll_actions ppa_arc
1658: where ppa.payroll_action_id between stpactid and enpactid
1659: and ppa_arc.payroll_action_id = pact_id
1660: and ppa.business_group_id = ppa_arc.business_group_id

Line 1657: pay_payroll_actions ppa_arc

1653: pact_id in number
1654: ) is
1655: select ppa.payroll_action_id
1656: from pay_payroll_actions ppa,
1657: pay_payroll_actions ppa_arc
1658: where ppa.payroll_action_id between stpactid and enpactid
1659: and ppa_arc.payroll_action_id = pact_id
1660: and ppa.business_group_id = ppa_arc.business_group_id
1661: and ppa.action_type in ('R', 'Q', 'B', 'I', 'V')

Line 1674: pay_payroll_actions ppa

1670: paf.person_id
1671: from
1672: per_periods_of_service pos,
1673: per_all_assignments_f paf,
1674: pay_payroll_actions ppa
1675: where pos.person_id between stperson and endperson
1676: and pos.person_id = paf.person_id
1677: and pos.period_of_service_id = paf.period_of_service_id
1678: and pos.business_group_id = ppa.business_group_id

Line 1692: pay_payroll_actions ppa,

1688: paf.person_id
1689: from
1690: per_periods_of_service pos,
1691: per_all_assignments_f paf,
1692: pay_payroll_actions ppa,
1693: pay_population_ranges ppr
1694: where ppr.chunk_number = c_chunk
1695: and ppr.payroll_action_id = ppa.payroll_action_id
1696: and pos.person_id = ppr.person_id

Line 1767: pay_payroll_actions ppa,

1763: from
1764: ( select distinct paf.assignment_id from
1765: per_periods_of_service pos,
1766: per_all_assignments_f paf,
1767: pay_payroll_actions ppa,
1768: pay_population_ranges ppr
1769: where ppr.chunk_number = p_chunk
1770: and ppr.payroll_action_id = ppa.payroll_action_id
1771: and pos.person_id = ppr.person_id

Line 1801: pay_payroll_actions ppa,

1797: from
1798: ( select distinct paf.assignment_id from
1799: per_periods_of_service pos,
1800: per_all_assignments_f paf,
1801: pay_payroll_actions ppa,
1802: pay_population_ranges ppr
1803: where pos.person_id between p_start_person_id and p_end_person_id
1804: and ppr.payroll_action_id = ppa.payroll_action_id
1805: and pos.person_id = paf.person_id

Line 1829: l_bus_grp pay_payroll_actions.business_group_id%type;

1825: --
1826: l_timeout_sec number;
1827: current_time date;
1828: l_run_bal_stat pay_balance_validation.run_balance_status%type;
1829: l_bus_grp pay_payroll_actions.business_group_id%type;
1830: l_request_id fnd_concurrent_requests.request_id%type;
1831: l_old_balance_load_date pay_balance_validation.balance_load_date%type;
1832: l_parm_purge_only varchar2(1);
1833: --

Line 1874: from pay_payroll_actions

1870:
1871: select business_group_id, request_id,
1872: nvl(pay_core_utils.get_parameter('PURGE_ONLY', legislative_parameters), 'N') parm_purge_only
1873: into l_bus_grp, l_request_id, l_parm_purge_only
1874: from pay_payroll_actions
1875: where payroll_action_id = p_payroll_action_id;
1876:
1877: select fcp.CONCURRENT_PROGRAM_NAME
1878: into g_program_name

Line 1938: pay_payroll_actions ppa_arch,

1934: ppa.action_sequence,
1935: ppa.effective_date,
1936: ppa.business_group_id
1937: from
1938: pay_payroll_actions ppa_arch,
1939: pay_payroll_actions ppa
1940: where ppa_arch.payroll_action_id = p_pact_id
1941: and ppa_arch.business_group_id = ppa.business_group_id
1942: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')

Line 1939: pay_payroll_actions ppa

1935: ppa.effective_date,
1936: ppa.business_group_id
1937: from
1938: pay_payroll_actions ppa_arch,
1939: pay_payroll_actions ppa
1940: where ppa_arch.payroll_action_id = p_pact_id
1941: and ppa_arch.business_group_id = ppa.business_group_id
1942: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1943: order by 2;

Line 2002: from pay_payroll_actions pa1

1998: --
1999: select pay_core_utils.get_parameter('REMOVE_ACT',
2000: pa1.legislative_parameters)
2001: into remove_act
2002: from pay_payroll_actions pa1
2003: where pa1.payroll_action_id = pactid;
2004: --
2005: if (remove_act is null or remove_act = 'Y') then
2006: pay_archive.remove_report_actions(pactid);