[Home] [Help]
202: ) + LENGTH(p_token)
203: )
204: )),
205: TRIM(business_group_id)
206: FROM pay_payroll_actions
207: WHERE payroll_action_id = p_pact_id;
208:
209: l_business_group_id VARCHAR2(300);
210: l_token_value VARCHAR2(300);
240: --8624704
241: )
242: )
243:
244: FROM pay_payroll_actions
245: WHERE payroll_action_id = p_pact_id;
246:
247:
248: BEGIN
503:
504:
505: CURSOR csr_archive_effective_date(pactid NUMBER) IS
506: SELECT effective_date
507: FROM pay_payroll_actions
508: WHERE payroll_action_id = pactid;
509:
510: /* 9719281 */
511: --
630: hr_utility.set_location('pactid '||TO_CHAR(pactid), 300);
631:
632: sqlstr := ' select distinct p.person_id' ||
633: ' from per_people_f p,' ||
634: ' pay_payroll_actions pa' ||
635: ' where pa.payroll_action_id = :payroll_action_id' ||
636: ' and p.business_group_id = pa.business_group_id' ||
637: ' order by p.person_id';
638:
962: l_select_str :='select distinct paaf.assignment_id asgid
963: from per_all_assignments_f paaf,
964: per_all_people_f ppf,
965: pay_all_payrolls_f papf,
966: pay_payroll_actions ppa,
967: hr_soft_coding_keyflex scl
968: where paaf.business_group_id = '|| g_business_group_id
969: ||' and papf.business_group_id = paaf.business_group_id '
970: ||' and paaf.effective_start_date <= '||''''||g_qtr_end_date||''''
1035:
1036:
1037: CURSOR csr_archive_effective_date(pactid NUMBER) IS
1038: SELECT effective_date
1039: FROM pay_payroll_actions
1040: WHERE payroll_action_id = pactid;
1041:
1042: BEGIN
1043:
1152: -- max(paa.assignment_action_id) assignment_action_id
1153: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1154: paa.assignment_action_id),16)) assignment_action_id /* 9852564 */
1155: FROM pay_assignment_actions paa,
1156: pay_payroll_actions ppa
1157: WHERE paa.assignment_id = p_asg_id
1158: AND ppa.payroll_action_id = paa.payroll_action_id
1159: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))
1160: AND ppa.effective_date between g_qtr_start_date and g_qtr_end_date
1195: CURSOR csr_paid_pay_periods (p_assignment_id per_all_assignments_f.assignment_id%type,
1196: p_payroll_id pay_all_payrolls.payroll_id%type) IS
1197: select count(ptp.time_period_id)
1198: from per_time_periods ptp,
1199: pay_payroll_actions ppa,
1200: pay_assignment_actions paa
1201: where ptp.payroll_id = p_payroll_id
1202: and ptp.regular_payment_date between g_qtr_start_date and g_qtr_end_date
1203: and ppa.payroll_id=p_payroll_id
1217: select count(ptp.time_period_id)
1218: from per_time_periods ptp
1219: where ptp.payroll_id = p_payroll_id
1220: and ptp.time_period_id in ( select ppa.time_period_id
1221: from pay_payroll_actions ppa,
1222: pay_assignment_actions paa
1223: where ppa.payroll_id=p_payroll_id
1224: and ppa.action_type in ('R', 'Q', 'I', 'V','B')
1225: and ppa.payroll_action_id=paa.payroll_action_id
2036: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2037:
2038: l_person_id per_all_people_f.person_id%TYPE;
2039: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2040: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2041: l_object_action_id pay_temp_object_actions.object_action_id%TYPE;
2042:
2043: CURSOR C_Perid_Asgid(p_payroll_action_id NUMBER, p_object_action_id NUMBER) IS
2044: SELECT DISTINCT ppf.person_id, paa.assignment_id
2043: CURSOR C_Perid_Asgid(p_payroll_action_id NUMBER, p_object_action_id NUMBER) IS
2044: SELECT DISTINCT ppf.person_id, paa.assignment_id
2045: FROM per_all_people_f ppf
2046: ,per_all_assignments_f paa
2047: ,pay_payroll_actions ppa
2048: ,pay_temp_object_actions ptoa
2049: WHERE paa.business_group_id = ppa.business_group_id
2050: AND paa.person_id = ppf.person_id
2051: AND ppa.payroll_action_id = p_payroll_action_id
2732: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2733: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2734: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2735: FROM pay_assignment_actions paa,
2736: pay_payroll_actions ppa
2737: WHERE
2738: paa.assignment_id = paaf.assignment_id
2739: AND ppa.payroll_action_id = paa.payroll_action_id
2740: -- AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))
2843: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2844: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2845: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2846: FROM pay_assignment_actions paa,
2847: pay_payroll_actions ppa
2848: WHERE
2849: paa.assignment_id = paaf.assignment_id
2850: AND ppa.payroll_action_id = paa.payroll_action_id
2851: -- AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))
2962: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2963: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2964: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2965: FROM pay_assignment_actions paa,
2966: pay_payroll_actions ppa
2967: WHERE
2968: paa.assignment_id = paaf.assignment_id
2969: AND ppa.payroll_action_id = paa.payroll_action_id
2970: AND (paa.source_action_id is not null or ppa.action_type in ('I','V'))
3095: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
3096: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
3097: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
3098: FROM pay_assignment_actions paa,
3099: pay_payroll_actions ppa
3100: WHERE
3101: paa.assignment_id = paaf.assignment_id
3102: AND ppa.payroll_action_id = paa.payroll_action_id
3103: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))