APPS.PAY_SG_CPFLINE dependencies on PAY_PAYROLL_ACTIONS

Line 12: report_type pay_payroll_actions.report_type%TYPE,

8: ----------------------------------------------------------------------
9: -- Record with payroll action details populated in Initialization_code
10: ----------------------------------------------------------------------
11: type t_pact IS RECORD(
12: report_type pay_payroll_actions.report_type%TYPE,
13: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
14: report_category pay_payroll_actions.report_category%TYPE,
15: business_group_id number,
16: effective_date date,

Line 13: report_qualifier pay_payroll_actions.report_qualifier%TYPE,

9: -- Record with payroll action details populated in Initialization_code
10: ----------------------------------------------------------------------
11: type t_pact IS RECORD(
12: report_type pay_payroll_actions.report_type%TYPE,
13: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
14: report_category pay_payroll_actions.report_category%TYPE,
15: business_group_id number,
16: effective_date date,
17: month_date varchar2(11),

Line 14: report_category pay_payroll_actions.report_category%TYPE,

10: ----------------------------------------------------------------------
11: type t_pact IS RECORD(
12: report_type pay_payroll_actions.report_type%TYPE,
13: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
14: report_category pay_payroll_actions.report_category%TYPE,
15: business_group_id number,
16: effective_date date,
17: month_date varchar2(11),
18: legal_entity_id number ,

Line 59: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

55: -- the archive process knows what code to execute for each step of
56: -- the archive.
57: --------------------------------------------------------------------
58: procedure range_code
59: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
60: p_sql out nocopy varchar2)
61: is
62: c_range_cursor constant varchar2(3000) :=
63: ' select distinct pap.person_id

Line 64: from pay_payroll_actions ppa,

60: p_sql out nocopy varchar2)
61: is
62: c_range_cursor constant varchar2(3000) :=
63: ' select distinct pap.person_id
64: from pay_payroll_actions ppa,
65: per_people_f pap
66: where ppa.payroll_action_id = :payroll_action_id
67: and pap.business_group_id = ppa.business_group_id
68: order by pap.person_id ' ;

Line 76: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

72: ------------------------------------------------------------
73: -- Assignment Action Code
74: ------------------------------------------------------------
75: procedure assignment_action_code
76: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
77: p_start_person_id in per_all_people_f.person_id%type,
78: p_end_person_id in per_all_people_f.person_id%type,
79: p_chunk in number )
80: is

Line 90: from pay_payroll_actions xppa,

86: ------------------------------------------------------------------------
87: cursor c_assact
88: is
89: select distinct paa.assignment_id
90: from pay_payroll_actions xppa,
91: pay_payroll_actions rppa,
92: pay_assignment_actions rpac,
93: per_assignments_f paa
94: where xppa.payroll_action_id = p_payroll_action_id

Line 91: pay_payroll_actions rppa,

87: cursor c_assact
88: is
89: select distinct paa.assignment_id
90: from pay_payroll_actions xppa,
91: pay_payroll_actions rppa,
92: pay_assignment_actions rpac,
93: per_assignments_f paa
94: where xppa.payroll_action_id = p_payroll_action_id
95: and paa.person_id between p_start_person_id

Line 161: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )

157: ------------------------------------------------------------
158: -- Assignment Action Code
159: ------------------------------------------------------------
160: procedure initialization_code
161: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
162: is
163:
164: begin
165: l_package := ' pay_sg_cpfline.';

Line 184: from pay_payroll_actions ppa

180: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters)) legal_entity_id,
181: to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)||'01','YYYYMMDD'),
182: last_day(to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)|| '01','YYYYMMDD'))
183: into g_pact
184: from pay_payroll_actions ppa
185: where ppa.payroll_action_id = p_payroll_action_id;
186: end if ;
187: --
188: if g_debug then

Line 207: l_payroll_id pay_payroll_actions.payroll_action_id%type ;

203: p_effective_date in date)
204: is
205: --
206: l_assignment_id per_all_assignments_f.assignment_id%type;
207: l_payroll_id pay_payroll_actions.payroll_action_id%type ;
208: --------------------------
209: -- Tables for pay_balance_pkg
210: --------------------------
211: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

Line 245: pay_payroll_actions rppa,

241: fnd_date.date_to_canonical(pps.date_start),
242: pap.person_id,
243: fnd_date.date_to_canonical(paa.effective_start_date)
244: from pay_assignment_actions pac,
245: pay_payroll_actions rppa,
246: pay_assignment_actions rpac,
247: per_assignments_f paa,
248: per_people_f pap,
249: per_periods_of_service pps,

Line 451: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )

447: -- table based on parameter value
448: -- Bug: 3619297 - Added check on action_context_type
449: ---------------------------------
450: procedure deinit_code
451: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
452: is
453: retain_archive_flag char(1) ;
454: begin
455: retain_archive_flag := 'N' ;

Line 458: from pay_payroll_actions ppa

454: begin
455: retain_archive_flag := 'N' ;
456: select pay_core_utils.get_parameter('RETAIN_ARCHIVE_DATA',ppa.legislative_parameters)
457: into retain_archive_flag
458: from pay_payroll_actions ppa
459: where ppa.payroll_action_id = p_payroll_action_id ;
460: --
461: if retain_archive_flag = 'N' then
462: delete from pay_action_information