APPS.PAY_ZA_MTC_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 38: from pay_assignment_actions

34:
35: -- Cursor used to update Tax Certificate Numbers
36: cursor c_tax_cert_no is
37: select serial_number
38: from pay_assignment_actions
39: where assignment_action_id = p_asg_action_id;
40:
41: -- Cursor used to find all the other Main Certificate Assignment Actions,
42: -- for the current Assignment in the same Tax Year

Line 45: from pay_assignment_actions paa,

41: -- Cursor used to find all the other Main Certificate Assignment Actions,
42: -- for the current Assignment in the same Tax Year
43: cursor other_ass_main is
44: select paa.serial_number, paa.assignment_action_id
45: from pay_assignment_actions paa,
46: pay_payroll_actions ppa
47: where ppa.business_group_id = p_bgid
48: and ppa.report_type = 'ZA_IRP5'
49: and ppa.action_type = 'X'

Line 58: from pay_assignment_actions paa2

54: and paa.assignment_id = p_asg_id
55: and paa.action_sequence =
56: (
57: select max(paa2.action_sequence)
58: from pay_assignment_actions paa2
59: where paa2.payroll_action_id = ppa.payroll_action_id
60: and paa2.assignment_id = p_asg_id
61: );
62:

Line 67: from pay_assignment_actions paa,

63: -- Cursor used to find all the other Lump Sum Certificate Assignment Actions for the
64: -- current Assignment in the same Tax Year, and for a specific Time Period ID
65: cursor other_ass_ls(p_period varchar2) is
66: select paa.serial_number, paa.assignment_action_id
67: from pay_assignment_actions paa,
68: pay_payroll_actions ppa,
69: ff_database_items dbi,
70: ff_archive_items arc
71: where ppa.business_group_id = p_bgid

Line 86: from pay_assignment_actions paa2

82: and arc.value = p_period
83: and paa.action_sequence <>
84: (
85: select max(paa2.action_sequence)
86: from pay_assignment_actions paa2
87: where paa2.payroll_action_id = ppa.payroll_action_id
88: and paa2.assignment_id = p_asg_id
89: );
90:

Line 94: l_old_num pay_assignment_actions.serial_number%type;

90:
91: -- Variables
92: l_old_cert_no varchar2(30);
93: l_lump_sum_ind varchar2(1);
94: l_old_num pay_assignment_actions.serial_number%type;
95: l_old_aa pay_assignment_actions.assignment_action_id%type;
96: l_period varchar2(240);
97:
98: begin

Line 95: l_old_aa pay_assignment_actions.assignment_action_id%type;

91: -- Variables
92: l_old_cert_no varchar2(30);
93: l_lump_sum_ind varchar2(1);
94: l_old_num pay_assignment_actions.serial_number%type;
95: l_old_aa pay_assignment_actions.assignment_action_id%type;
96: l_period varchar2(240);
97:
98: begin
99:

Line 129: pay_assignment_actions paa_arch

125:
126: Select decode(count(*), 0 ,'Y', 'N')
127: into l_lump_sum_ind
128: From pay_payroll_actions ppa_arch,
129: pay_assignment_actions paa_arch
130: where paa_arch.assignment_action_id = p_asg_action_id
131: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
132: and paa_arch.assignment_action_id =
133: (

Line 135: from pay_assignment_actions paa

131: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
132: and paa_arch.assignment_action_id =
133: (
134: select max(paa.assignment_action_id)
135: from pay_assignment_actions paa
136: where paa.payroll_action_id = ppa_arch.payroll_action_id
137: and paa.assignment_id = paa_arch.assignment_id
138: ) ;
139: /* commented for 6266019

Line 183: update pay_assignment_actions

179:
180: if substr(l_old_num, 1, 2) <> '&&' then
181:
182: -- Update the Assignment Action to reflect that this is an old number
183: update pay_assignment_actions
184: set serial_number = '&&' || l_old_num
185: where assignment_action_id = l_old_aa;
186:
187: end if;

Line 245: update pay_assignment_actions

241:
242: if substr(l_old_num, 1, 2) <> '&&' then
243:
244: -- Update the Assignment Action to reflect that this is an old number
245: update pay_assignment_actions
246: set serial_number = '&&' || l_old_num
247: where assignment_action_id = l_old_aa;
248:
249: end if;

Line 262: update pay_assignment_actions

258:
259: end if;
260:
261: -- The Tax Certificate Number is updateable
262: update pay_assignment_actions
263: set serial_number = p_tax_cert_no
264: where assignment_action_id = p_asg_action_id;
265:
266: -- Commit the record

Line 300: from pay_assignment_actions

296:
297: --Cursor to get the assignment action id
298: cursor csr_ass_act_id is
299: select assignment_action_id
300: from pay_assignment_actions
301: where payroll_action_id = p_pay_action_id
302: and assignment_id = p_asg_id;
303:
304: --Cursor to get the certificate number

Line 305: cursor csr_cert_details (ass_act_id pay_assignment_actions.assignment_action_id%type

301: where payroll_action_id = p_pay_action_id
302: and assignment_id = p_asg_id;
303:
304: --Cursor to get the certificate number
305: cursor csr_cert_details (ass_act_id pay_assignment_actions.assignment_action_id%type
306: ,p_cert_num varchar2) IS
307: select pai.action_information1 cert_num, -- Certificate Number
308: pai.action_information29 man_cert_num, -- Manual Certificate Number
309: pai.action_information28 cert_ind, -- O for old electronic, M for manual, OM for old manual

Line 342: from pay_assignment_actions paa,

338: pai.action_information20 directive3, -- Directive 3
339: pai2.action_information26 cert_type, --MAIN/LMPSM
340: pai.action_information_id act_inf_id,
341: pai2.action_information_id act_inf_id2
342: from pay_assignment_actions paa,
343: pay_payroll_actions ppa,
344: pay_action_information pai, --For Employee Info
345: pay_action_information pai2 --For Employee contact info
346: where ppa.business_group_id = p_bgid

Line 369: l_ass_act_id pay_assignment_actions.assignment_action_id%type;

365: and pai2.action_information26 = p_cert_type;
366:
367: l_proc varchar2(100):='PAY_ZA_MTC_PKG.upd_certificate_num_EOY2010';
368: rec_cert_details csr_cert_details%rowtype;
369: l_ass_act_id pay_assignment_actions.assignment_action_id%type;
370: rec_other_ass_actions csr_other_ass_actions%rowtype;
371: begin
372: hr_utility.set_location('Entering '||l_proc,10);
373: hr_utility.set_location('p_bgid :'||p_bgid,10);