[Home] [Help]
1273: -- starts with IE_A
1274: -- First part of the select retrives summed up values for Payroll runs,
1275: -- Second part of the select retrives summed up values for Uploaded Balance
1276: /* CURSOR csr_iea_weeks (p_balance_type_id in number) IS
1277: select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0) weeks
1278: from pay_run_result_values TARGET
1279: , pay_balance_feeds_f FEED
1280: , pay_run_results RR
1281: , pay_assignment_actions ASSACT
1319: and ACX_PROCESS_ID.context_value like 'IE_A%'
1320: and PPTP.regular_payment_date >= trunc(BPTP.regular_payment_date,'Y')
1321: and RR.entry_type <>'B' -- Bug 3079945 start
1322: union all
1323: select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0) weeks
1324: from pay_run_result_values TARGET
1325: , pay_run_results RR
1326: , pay_assignment_actions ASSACT
1327: , pay_balance_feeds_f FEED
3203: CURSOR cur_child_pay_action (p_person_id IN NUMBER,
3204: p_effective_date IN DATE,
3205: p_lat_act_seq IN NUMBER) is
3206: SELECT /*+ USE_NL(paa, ppa) */
3207: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3208: paa.assignment_action_id),16))
3209: FROM pay_assignment_actions paa,
3210: pay_payroll_actions ppa
3211: WHERE paa.payroll_action_id = ppa.payroll_action_id
3244: AND pai_p45.action_information8 = to_char(p_person_id);
3245:
3246: -- Cursor to fetch action context id of P45 for previous period of service.
3247: CURSOR cur_get_last_p45(p_person_id NUMBER,p_termination_date DATE,p_pact NUMBER) IS
3248: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3249: paa.assignment_action_id),16))
3250: FROM pay_payroll_actions ppa,
3251: pay_assignment_actions paa,
3252: pay_action_information pai