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 449: from pay_assignment_actions paa,

445: pbg.legislation_code
446: into l_asg_id,
447: l_bus_grp_id,
448: l_leg_code
449: from pay_assignment_actions paa,
450: pay_payroll_actions ppa,
451: per_business_groups_perf pbg
452: where paa.assignment_action_id = p_asg_act_id
453: and ppa.business_group_id = pbg.business_group_id

Line 671: pay_assignment_actions paa,

667: l_prd_end_date,
668: l_prd_start_date,
669: l_prorate_grp_id
670: from pay_payroll_actions ppa,
671: pay_assignment_actions paa,
672: per_time_periods ptp,
673: pay_element_types_f pet
674: where paa.assignment_action_id = p_asg_act_id
675: and paa.payroll_action_id = ppa.payroll_action_id

Line 743: select pay_assignment_actions_s.nextval

739: is
740: aa_id number;
741: begin
742: --
743: select pay_assignment_actions_s.nextval
744: into aa_id
745: from sys.dual;
746: --
747: p_aa_id_list := aa_id;

Line 961: pay_assignment_actions paa,

957: --
958: select INTLK.locking_action_id
959: into l_action_id
960: from pay_action_interlocks INTLK,
961: pay_assignment_actions paa,
962: pay_payroll_actions ppa
963: where INTLK.locked_action_id = p_action_id
964: and INTLK.locking_action_id = paa.assignment_action_id
965: and paa.payroll_action_id = ppa.payroll_action_id

Line 1021: from pay_assignment_actions paa,

1017: is
1018: select paa.assignment_action_id,
1019: nvl(prt.run_method, 'N'),
1020: paa.start_date
1021: from pay_assignment_actions paa,
1022: pay_run_types_f prt
1023: where paa.source_action_id = p_action
1024: and paa.run_type_id = prt.run_type_id (+);
1025: --

Line 1026: l_child_action pay_assignment_actions.assignment_action_id%type;

1022: pay_run_types_f prt
1023: where paa.source_action_id = p_action
1024: and paa.run_type_id = prt.run_type_id (+);
1025: --
1026: l_child_action pay_assignment_actions.assignment_action_id%type;
1027: l_run_method pay_run_types.run_method%type;
1028: l_start_date pay_assignment_actions.start_date%type;
1029: --
1030: begin

Line 1028: l_start_date pay_assignment_actions.start_date%type;

1024: and paa.run_type_id = prt.run_type_id (+);
1025: --
1026: l_child_action pay_assignment_actions.assignment_action_id%type;
1027: l_run_method pay_run_types.run_method%type;
1028: l_start_date pay_assignment_actions.start_date%type;
1029: --
1030: begin
1031: --
1032: open get_actions(p_cur_action_id);

Line 1066: pay_assignment_actions paa,

1062: select nvl(nvl(prt_aa.run_method, prt_pa.run_method), 'N')
1063: into l_run_method
1064: from pay_run_types_f prt_aa,
1065: pay_run_types_f prt_pa,
1066: pay_assignment_actions paa,
1067: pay_payroll_actions ppa
1068: where paa.assignment_action_id = p_calling_action_id
1069: and paa.payroll_action_id = ppa.payroll_action_id
1070: and paa.run_type_id = prt_aa.run_type_id (+)

Line 1817: pay_assignment_actions paa,

1813: ppa.effective_date
1814: into l_run_meth,
1815: l_eff_date
1816: from pay_run_types_f prt,
1817: pay_assignment_actions paa,
1818: pay_payroll_actions ppa
1819: where paa.assignment_action_id = p_asg_action_id
1820: and ppa.payroll_action_id = paa.payroll_action_id
1821: and nvl(paa.run_type_id, -999) = prt.run_type_id (+)

Line 1845: l_run_type_id pay_assignment_actions.run_type_id%type;

1841: procedure get_process_path(p_asg_action_id in number,
1842: p_process_path in out nocopy varchar2)
1843: is
1844: --
1845: l_run_type_id pay_assignment_actions.run_type_id%type;
1846: l_src_id pay_assignment_actions.source_action_id%type;
1847: l_ee_trigger pay_element_entries_f.element_entry_id%type;
1848: l_start_date varchar2(30);
1849: l_end_date varchar2(30);

Line 1846: l_src_id pay_assignment_actions.source_action_id%type;

1842: p_process_path in out nocopy varchar2)
1843: is
1844: --
1845: l_run_type_id pay_assignment_actions.run_type_id%type;
1846: l_src_id pay_assignment_actions.source_action_id%type;
1847: l_ee_trigger pay_element_entries_f.element_entry_id%type;
1848: l_start_date varchar2(30);
1849: l_end_date varchar2(30);
1850: begin

Line 1860: from pay_assignment_actions

1856: into l_run_type_id,
1857: l_src_id,
1858: l_start_date,
1859: l_end_date
1860: from pay_assignment_actions
1861: where assignment_action_id = p_asg_action_id;
1862: --
1863: l_ee_trigger := get_proc_sep_trigger(p_asg_action_id);
1864: --

Line 2288: from pay_assignment_actions paa,

2284: --
2285: if (g_leg_code is null) then
2286: select pbg.legislation_code
2287: into g_leg_code
2288: from pay_assignment_actions paa,
2289: pay_payroll_actions ppa,
2290: per_business_groups_perf pbg
2291: where paa.assignment_action_id = p_asg_act_id
2292: and ppa.business_group_id = pbg.business_group_id

Line 2459: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE ,

2455: end is_element_included;
2456: --
2457: /* Bug 11708644, PAYROLL/PROJECTS INTEGRATION FOR 12.2 */
2458: PROCEDURE update_prj_flag ( p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2459: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE ,
2460: p_flag IN VARCHAR2,
2461: p_status OUT NOCOPY varchar2
2462: ) IS
2463: lv_proc VARCHAR2(30) := 'update_prj_flag';