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 98: from pay_payroll_actions ppa,

94: nvl(pay_core_utils.get_parameter('BAL_LVL',
95: ppa.legislative_parameters),
96: 'BOTH') balance_level,
97: pbd.dimension_level
98: from pay_payroll_actions ppa,
99: per_business_groups pbg,
100: pay_defined_balances pdb,
101: pay_balance_dimensions pbd
102: where ppa.payroll_action_id = p_pact_id

Line 127: l_bus_grp pay_payroll_actions.business_group_id%type;

123: = 'BOTH')
124: );
125: --
126: l_run_bal_stat pay_balance_validation.run_balance_status%type;
127: l_bus_grp pay_payroll_actions.business_group_id%type;
128: --
129: begin
130: --
131: if (g_proc_mode <> 'SINGLE') then

Line 189: from pay_payroll_actions

185: /* Single Balance load */
186: --
187: select business_group_id
188: into l_bus_grp
189: from pay_payroll_actions
190: where payroll_action_id = p_pactid;
191: --
192: if (g_load_type <> 'DELTA') then
193: --

Line 260: from pay_payroll_actions pa1,

256: g_load_type,
257: g_leg_code,
258: g_bus_grp,
259: g_att_name
260: from pay_payroll_actions pa1,
261: per_business_groups pbg
262: where pa1.payroll_action_id = p_pact_id
263: and pa1.business_group_id = pbg.business_group_id;
264: --

Line 511: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)

507: --
508: cursor getaa (p_assid in number
509: ) is
510: select /*+ ORDERED USE_NL(ppa prt)
511: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
512: INDEX(prt PAY_RUN_TYPES_PK) */
513: paa.assignment_action_id,
514: ppa.effective_date,
515: nvl(prt.run_method, 'N') run_method,

Line 519: pay_payroll_actions ppa,

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
523: and paa.payroll_action_id = ppa.payroll_action_id

Line 879: l_bus_grp pay_payroll_actions.business_group_id%type;

875:
876: procedure process_group_lvl_balances( p_pactid in number)
877: is
878: l_grp_eff_date date;
879: l_bus_grp pay_payroll_actions.business_group_id%type;
880: l_run_bal_status pay_balance_validation.run_balance_status%type;
881: l_bal_load_date pay_balance_validation.balance_load_date%type;
882: l_leg_code per_business_groups.legislation_code%type;
883: begin

Line 892: from pay_payroll_actions ppa,

888: pbg.legislation_code
889: into l_grp_eff_date,
890: l_bus_grp,
891: l_leg_code
892: from pay_payroll_actions ppa,
893: per_business_groups pbg
894: where ppa.payroll_action_id = p_pactid
895: and ppa.business_group_id = pbg.business_group_id;
896: exception

Line 1016: pay_payroll_actions ppa,

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
1020: and paa_arch.assignment_id = paa.assignment_id

Line 1034: l_bus_grp pay_payroll_actions.business_group_id%type;

1030: l_payroll_action_id number;
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(

Line 1047: pay_payroll_actions ppa

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: --
1051: set_globals(l_payroll_action_id);

Line 1307: from pay_payroll_actions ppa,

1303: if (g_bal_lvl = 'GRP') then
1304: if (g_save_run_bals = 'Y') then
1305: lv_sql_string :=
1306: 'select ppa_r.payroll_action_id
1307: from pay_payroll_actions ppa,
1308: pay_payroll_actions ppa_r
1309: where ppa.payroll_action_id = :payroll_action_id
1310: and ppa_r.action_type in (''R'',''Q'',''B'', ''I'',''V'')
1311: and ppa.business_group_id = ppa_r.business_group_id

Line 1308: pay_payroll_actions ppa_r

1304: if (g_save_run_bals = 'Y') then
1305: lv_sql_string :=
1306: 'select ppa_r.payroll_action_id
1307: from pay_payroll_actions ppa,
1308: pay_payroll_actions ppa_r
1309: where ppa.payroll_action_id = :payroll_action_id
1310: and ppa_r.action_type in (''R'',''Q'',''B'', ''I'',''V'')
1311: and ppa.business_group_id = ppa_r.business_group_id
1312: order by ppa_r.payroll_action_id';

Line 1321: pay_payroll_actions ppa

1317: 'select distinct asg.person_id
1318: from
1319: per_periods_of_service pos,
1320: per_assignments_f asg,
1321: pay_payroll_actions ppa
1322: where ppa.payroll_action_id = :payroll_action_id
1323: and pos.person_id = asg.person_id
1324: and pos.period_of_service_id = asg.period_of_service_id
1325: and pos.business_group_id = ppa.business_group_id

Line 1361: from pay_payroll_actions ppa,

1357: enpactid in number,
1358: pact_id in number
1359: ) is
1360: select ppa.payroll_action_id
1361: from pay_payroll_actions ppa,
1362: pay_payroll_actions ppa_arc
1363: where ppa.payroll_action_id between stpactid and enpactid
1364: and ppa_arc.payroll_action_id = pact_id
1365: and ppa.business_group_id = ppa_arc.business_group_id

Line 1362: pay_payroll_actions ppa_arc

1358: pact_id in number
1359: ) is
1360: select ppa.payroll_action_id
1361: from pay_payroll_actions ppa,
1362: pay_payroll_actions ppa_arc
1363: where ppa.payroll_action_id between stpactid and enpactid
1364: and ppa_arc.payroll_action_id = pact_id
1365: and ppa.business_group_id = ppa_arc.business_group_id
1366: and ppa.action_type in ('R', 'Q', 'B', 'I', 'V')

Line 1379: pay_payroll_actions ppa

1375: paf.person_id
1376: from
1377: per_periods_of_service pos,
1378: per_all_assignments_f paf,
1379: pay_payroll_actions ppa
1380: where pos.person_id between stperson and endperson
1381: and pos.person_id = paf.person_id
1382: and pos.period_of_service_id = paf.period_of_service_id
1383: and pos.business_group_id = ppa.business_group_id

Line 1499: pay_payroll_actions ppa_arch,

1495: ppa.action_sequence,
1496: ppa.effective_date,
1497: ppa.business_group_id
1498: from
1499: pay_payroll_actions ppa_arch,
1500: pay_payroll_actions ppa
1501: where ppa_arch.payroll_action_id = p_pact_id
1502: and ppa_arch.business_group_id = ppa.business_group_id
1503: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')

Line 1500: pay_payroll_actions ppa

1496: ppa.effective_date,
1497: ppa.business_group_id
1498: from
1499: pay_payroll_actions ppa_arch,
1500: pay_payroll_actions ppa
1501: where ppa_arch.payroll_action_id = p_pact_id
1502: and ppa_arch.business_group_id = ppa.business_group_id
1503: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1504: order by 2;

Line 1563: from pay_payroll_actions pa1

1559: --
1560: select pay_core_utils.get_parameter('REMOVE_ACT',
1561: pa1.legislative_parameters)
1562: into remove_act
1563: from pay_payroll_actions pa1
1564: where pa1.payroll_action_id = pactid;
1565: --
1566: if (remove_act is null or remove_act = 'Y') then
1567: pay_archive.remove_report_actions(pactid);