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_CORE_UTILS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 39: g_asg_action_id pay_assignment_actions.assignment_action_id%type;

35: g_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;
36: g_leg_code pay_legislation_contexts.legislation_code%type := null;
37: --
38: g_process_path varchar2(2000);
39: g_asg_action_id pay_assignment_actions.assignment_action_id%type;
40: --
41: -- Legislative context IV names cache. used in get_leg_context_iv_name.
42: --
43: type t_leg_context_iv_rec is record

Line 357: from pay_assignment_actions paa,

353: pbg.legislation_code
354: into l_asg_id,
355: l_bus_grp_id,
356: l_leg_code
357: from pay_assignment_actions paa,
358: pay_payroll_actions ppa,
359: per_business_groups_perf pbg
360: where paa.assignment_action_id = p_asg_act_id
361: and ppa.business_group_id = pbg.business_group_id

Line 579: pay_assignment_actions paa,

575: l_prd_end_date,
576: l_prd_start_date,
577: l_prorate_grp_id
578: from pay_payroll_actions ppa,
579: pay_assignment_actions paa,
580: per_time_periods ptp,
581: pay_element_types_f pet
582: where paa.assignment_action_id = p_asg_act_id
583: and paa.payroll_action_id = ppa.payroll_action_id

Line 651: select pay_assignment_actions_s.nextval

647: is
648: aa_id number;
649: begin
650: --
651: select pay_assignment_actions_s.nextval
652: into aa_id
653: from sys.dual;
654: --
655: p_aa_id_list := aa_id;

Line 869: pay_assignment_actions paa,

865: --
866: select INTLK.locking_action_id
867: into l_action_id
868: from pay_action_interlocks INTLK,
869: pay_assignment_actions paa,
870: pay_payroll_actions ppa
871: where INTLK.locked_action_id = p_action_id
872: and INTLK.locking_action_id = paa.assignment_action_id
873: and paa.payroll_action_id = ppa.payroll_action_id

Line 929: from pay_assignment_actions paa,

925: is
926: select paa.assignment_action_id,
927: nvl(prt.run_method, 'N'),
928: paa.start_date
929: from pay_assignment_actions paa,
930: pay_run_types_f prt
931: where paa.source_action_id = p_action
932: and paa.run_type_id = prt.run_type_id (+);
933: --

Line 934: l_child_action pay_assignment_actions.assignment_action_id%type;

930: pay_run_types_f prt
931: where paa.source_action_id = p_action
932: and paa.run_type_id = prt.run_type_id (+);
933: --
934: l_child_action pay_assignment_actions.assignment_action_id%type;
935: l_run_method pay_run_types.run_method%type;
936: l_start_date pay_assignment_actions.start_date%type;
937: --
938: begin

Line 936: l_start_date pay_assignment_actions.start_date%type;

932: and paa.run_type_id = prt.run_type_id (+);
933: --
934: l_child_action pay_assignment_actions.assignment_action_id%type;
935: l_run_method pay_run_types.run_method%type;
936: l_start_date pay_assignment_actions.start_date%type;
937: --
938: begin
939: --
940: open get_actions(p_cur_action_id);

Line 974: pay_assignment_actions paa,

970: select nvl(nvl(prt_aa.run_method, prt_pa.run_method), 'N')
971: into l_run_method
972: from pay_run_types_f prt_aa,
973: pay_run_types_f prt_pa,
974: pay_assignment_actions paa,
975: pay_payroll_actions ppa
976: where paa.assignment_action_id = p_calling_action_id
977: and paa.payroll_action_id = ppa.payroll_action_id
978: and paa.run_type_id = prt_aa.run_type_id (+)

Line 1704: pay_assignment_actions paa,

1700: ppa.effective_date
1701: into l_run_meth,
1702: l_eff_date
1703: from pay_run_types_f prt,
1704: pay_assignment_actions paa,
1705: pay_payroll_actions ppa
1706: where paa.assignment_action_id = p_asg_action_id
1707: and ppa.payroll_action_id = paa.payroll_action_id
1708: and nvl(paa.run_type_id, -999) = prt.run_type_id (+)

Line 1732: l_run_type_id pay_assignment_actions.run_type_id%type;

1728: procedure get_process_path(p_asg_action_id in number,
1729: p_process_path in out nocopy varchar2)
1730: is
1731: --
1732: l_run_type_id pay_assignment_actions.run_type_id%type;
1733: l_src_id pay_assignment_actions.source_action_id%type;
1734: l_ee_trigger pay_element_entries_f.element_entry_id%type;
1735: l_start_date varchar2(30);
1736: l_end_date varchar2(30);

Line 1733: l_src_id pay_assignment_actions.source_action_id%type;

1729: p_process_path in out nocopy varchar2)
1730: is
1731: --
1732: l_run_type_id pay_assignment_actions.run_type_id%type;
1733: l_src_id pay_assignment_actions.source_action_id%type;
1734: l_ee_trigger pay_element_entries_f.element_entry_id%type;
1735: l_start_date varchar2(30);
1736: l_end_date varchar2(30);
1737: begin

Line 1747: from pay_assignment_actions

1743: into l_run_type_id,
1744: l_src_id,
1745: l_start_date,
1746: l_end_date
1747: from pay_assignment_actions
1748: where assignment_action_id = p_asg_action_id;
1749: --
1750: l_ee_trigger := get_proc_sep_trigger(p_asg_action_id);
1751: --

Line 2167: from pay_assignment_actions paa,

2163: --
2164: if (g_leg_code is null) then
2165: select pbg.legislation_code
2166: into g_leg_code
2167: from pay_assignment_actions paa,
2168: pay_payroll_actions ppa,
2169: per_business_groups_perf pbg
2170: where paa.assignment_action_id = p_asg_act_id
2171: and ppa.business_group_id = pbg.business_group_id