APPS.PAY_CORE_UTILS dependencies on PAY_RUN_TYPES

Line 1006: l_run_method pay_run_types_f.run_method%type;

1002: ) return varchar2
1003: is
1004: --
1005: l_include varchar2(5);
1006: l_run_method pay_run_types_f.run_method%type;
1007: l_child_run_method pay_run_types_f.run_method%type;
1008: l_found boolean;
1009: --
1010: procedure get_action_component(p_cur_action_id in number,

Line 1007: l_child_run_method pay_run_types_f.run_method%type;

1003: is
1004: --
1005: l_include varchar2(5);
1006: l_run_method pay_run_types_f.run_method%type;
1007: l_child_run_method pay_run_types_f.run_method%type;
1008: l_found boolean;
1009: --
1010: procedure get_action_component(p_cur_action_id in number,
1011: p_srch_action_id in number,

Line 1022: pay_run_types_f prt

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: --
1026: l_child_action pay_assignment_actions.assignment_action_id%type;

Line 1027: l_run_method pay_run_types.run_method%type;

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
1031: --

Line 1064: from pay_run_types_f prt_aa,

1060: elsif (p_calling_action_type in ('R', 'Q')) then
1061: --
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

Line 1065: pay_run_types_f prt_pa,

1061: --
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

Line 1806: l_run_meth pay_run_types_f.run_method%type;

1802: decode (prr.entry_type,
1803: 'S', 1,
1804: 2);
1805: --
1806: l_run_meth pay_run_types_f.run_method%type;
1807: l_eff_date pay_payroll_actions.effective_date%type;
1808: l_ee_id pay_run_results.source_id%type;
1809: --
1810: begin

Line 1816: from pay_run_types_f prt,

1812: select nvl(prt.run_method, 'N'),
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