[Home] [Help]
123: -- BUG 3453612
124: AND xppa.effective_date between asg.effective_start_date and asg.effective_end_date
125: AND NOT EXISTS (SELECT NULL
126: FROM pay_payroll_actions ppa4,
127: pay_assignment_actions paa4
128: WHERE paa4.assignment_id = asg.assignment_id
129: AND paa4.source_action_id IS NULL
130: AND ppa4.payroll_action_id = paa4.payroll_action_id
131: AND ppa4.action_type = 'X'
140: AND pei.pei_information6 = 'Y'
141: AND pei.information_type = 'PER_KR_HEALTH_INSURANCE_INFO'))
142: AND EXISTS (SELECT NULL
143: FROM pay_payroll_actions ppa,
144: pay_assignment_actions paa
145: WHERE ppa.effective_date BETWEEN
146: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters)), 'YYYY')
147: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters))
148: AND ppa.action_type in ('R','Q')
158: initialization_code(p_payroll_action_id);
159:
160: FOR l_asg IN csr_asg -- 3506171
161: LOOP
162: SELECT pay_assignment_actions_s.nextval
163: INTO l_locking_action_id
164: FROM dual;
165: hr_nonrun_asact.insact(lockingactid => l_locking_action_id,
166: assignid => l_asg.assignment_id,
184: -- Archives item
185: --------------------------------------------------------------------------------+
186: PROCEDURE archive_item
187: ( p_item IN ff_user_entities.user_entity_name%TYPE,
188: p_context1 IN pay_assignment_actions.assignment_action_id%TYPE,
189: p_value IN OUT NOCOPY ff_archive_items.value%TYPE)
190: IS
191: CURSOR csr_get_user_entity_id(c_user_entity_name IN VARCHAR2)
192: IS
279: SELECT paa.assignment_id,
280: pa.payroll_id,
281: pa.establishment_id -- 3506171
282: FROM per_assignments_f pa,
283: pay_assignment_actions paa
284: WHERE paa.assignment_action_id = p_assignment_action_id
285: AND pa.assignment_id = paa.assignment_id
286: AND g_pact.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date;
287:
296: NULL business_place_unit
297: FROM per_people_extra_info pei,
298: per_people_f pp,
299: per_assignments_f pa,
300: pay_assignment_actions paa,
301: pay_payroll_actions ppa,
302: hr_organization_information hhoi,
303: per_periods_of_service pds
304: WHERE ppa.payroll_action_id = g_pact.payroll_action_id
333: /* Bug 4199014: Performance update - Removed check for balance value (call to PAY_BALANCE_PKG.GET_VALUE)
334: from the WHERE clause. Changed the SELECT clause, added extra WHERE predicate
335: (PAA.ACTION_STATUS).
336: */
337: cursor csr_hi_no_of_mths_prem_paid(p_assact_id pay_assignment_actions.assignment_action_id%type ,
338: p_start_date date ,
339: p_end_date date )
340: is
341: select paa.assignment_action_id
339: p_end_date date )
340: is
341: select paa.assignment_action_id
342: ,to_number(to_char(ppa.effective_date,'MM') )
343: from pay_assignment_actions xpaa
344: ,pay_payroll_actions xppa
345: ,pay_payroll_actions ppa
346: ,pay_assignment_actions paa
347: ,pay_run_types_f prt
342: ,to_number(to_char(ppa.effective_date,'MM') )
343: from pay_assignment_actions xpaa
344: ,pay_payroll_actions xppa
345: ,pay_payroll_actions ppa
346: ,pay_assignment_actions paa
347: ,pay_run_types_f prt
348: where xpaa.assignment_action_id = p_assact_id
349: and xppa.payroll_action_id = xpaa.payroll_action_id
350: and xpaa.assignment_id = paa.assignment_id
364: -- Bug 3438946
365: Cursor csr_last_year_asg_action
366: IS
367: SELECT paa.assignment_action_id
368: FROM pay_assignment_actions paa,
369: per_assignments_f pa,
370: pay_payroll_actions ppa
371: WHERE pa.assignment_id = l_assignment_id
372: AND paa.assignment_id = l_assignment_id