DBA Data[Home] [Help]

APPS.PAY_CORE_UTILS dependencies on PAY_RUN_TYPES_F

Line 914: l_run_method pay_run_types_f.run_method%type;

910: ) return varchar2
911: is
912: --
913: l_include varchar2(5);
914: l_run_method pay_run_types_f.run_method%type;
915: l_child_run_method pay_run_types_f.run_method%type;
916: l_found boolean;
917: --
918: procedure get_action_component(p_cur_action_id in number,

Line 915: l_child_run_method pay_run_types_f.run_method%type;

911: is
912: --
913: l_include varchar2(5);
914: l_run_method pay_run_types_f.run_method%type;
915: l_child_run_method pay_run_types_f.run_method%type;
916: l_found boolean;
917: --
918: procedure get_action_component(p_cur_action_id in number,
919: p_srch_action_id in number,

Line 930: pay_run_types_f prt

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

Line 972: from pay_run_types_f prt_aa,

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

Line 973: pay_run_types_f prt_pa,

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

Line 1693: l_run_meth pay_run_types_f.run_method%type;

1689: decode (prr.entry_type,
1690: 'S', 1,
1691: 2);
1692: --
1693: l_run_meth pay_run_types_f.run_method%type;
1694: l_eff_date pay_payroll_actions.effective_date%type;
1695: l_ee_id pay_run_results.source_id%type;
1696: --
1697: begin

Line 1703: from pay_run_types_f prt,

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