[Home] [Help]
337: 'TRANSFER_CONSOLIDATION_SET_ID=') - 1 )
338: - (instr(legislative_parameters,
339: 'TRANSFER_PAYROLL_ID=')
340: + length('TRANSFER_PAYROLL_ID='))))))
341: from pay_payroll_actions
342: where payroll_action_id = cp_payroll_action_id;
343:
344: ld_end_date DATE;
345: ld_start_date DATE;
587: cursor c_last_payment_info(cp_assignment_id in number
588: ,cp_curr_pymt_eff_date in date) is
589:
590: select ppa.effective_date, paa.assignment_action_id
591: from pay_payroll_actions ppa,
592: pay_assignment_actions paa
593: where paa.assignment_id = p_assignment_id
594: and ppa.payroll_action_id = paa.payroll_action_id
595: and ppa.action_type in ('U','P')
595: and ppa.action_type in ('U','P')
596: and ppa.effective_date < p_curr_pymt_eff_date
597: and ppa.effective_date in
598: ( select max(ppa1.effective_date)
599: from pay_payroll_actions ppa1,
600: pay_assignment_actions paa1
601: where ppa1.payroll_action_id = paa1.payroll_action_id
602: and ppa1.action_type in ('U','P')
603: and paa1.assignment_id = p_assignment_id
690: ,cp_sepchk_run_type in number) is
691: select paa.assignment_action_id
692: from pay_assignment_actions paa,
693: pay_action_interlocks pai,
694: pay_payroll_actions ppa
695: where pai.locking_action_id = cp_prepayment_action_id
696: and paa.assignment_action_id = pai.locked_action_id
697: and paa.assignment_id = cp_assignment_id
698: and ppa.payroll_action_id = paa.payroll_action_id
713: ,cp_sepchk_run_type in number) is
714: select paa.assignment_action_id
715: from pay_assignment_actions paa,
716: pay_action_interlocks pai,
717: pay_payroll_actions ppa
718: where pai.locking_action_id = cp_prepayment_action_id
719: and paa.assignment_action_id = pai.locked_action_id
720: and paa.assignment_id = cp_assignment_id
721: and paa.tax_unit_id = cp_tax_unit_id
733: select ptp.time_period_id,
734: ppa.date_earned,
735: ppa.effective_date
736: from pay_assignment_actions paa,
737: pay_payroll_actions ppa,
738: per_time_periods ptp
739: where paa.assignment_action_id = cp_run_assignment_action
740: and ppa.payroll_action_id = paa.payroll_action_id
741: and ptp.payroll_id = ppa.payroll_id
1133: cursor c_get_pp_actid_of_sepchk(cp_source_action_id number) is
1134: select paa.assignment_action_id
1135: from pay_action_interlocks pai
1136: ,pay_assignment_actions paa
1137: ,pay_payroll_actions ppa
1138: where pai.locked_action_id = cp_source_action_id
1139: and paa.assignment_action_id = pai.locking_action_id
1140: and paa.source_action_id is not null
1141: and ppa.payroll_action_id = paa.payroll_action_id
1147: ,cp_assignment_id number) is
1148: select paa.assignment_action_id,ppa_run.action_type
1149: from pay_assignment_actions paa
1150: ,pay_action_interlocks pai
1151: ,pay_payroll_actions ppa_run
1152: where pai.locking_action_id = cp_pp_asg_act_id
1153: and paa.assignment_action_id = pai.locked_action_id
1154: and paa.assignment_id = cp_assignment_id
1155: and paa.source_action_id is null
1469: cursor c_get_pp_actid_of_sepchk(cp_source_action_id number) is
1470: select paa.assignment_action_id
1471: from pay_action_interlocks pai
1472: ,pay_assignment_actions paa
1473: ,pay_payroll_actions ppa
1474: where pai.locked_action_id = cp_source_action_id
1475: and paa.assignment_action_id = pai.locking_action_id
1476: and paa.source_action_id is not null
1477: and ppa.payroll_action_id = paa.payroll_action_id
2180: paa.assignment_id,
2181: paa.tax_unit_id,
2182: paa.assignment_action_id,
2183: ppp.source_action_id
2184: from pay_payroll_actions ppa
2185: ,pay_assignment_actions paa
2186: ,pay_pre_payments ppp
2187: ,pay_org_payment_methods popm
2188: where ppa.consolidation_set_id
2473: cursor c_assignment_run (cp_prepayment_action_id in number) is
2474: select distinct paa.assignment_id
2475: from pay_action_interlocks pai,
2476: pay_assignment_actions paa,
2477: pay_payroll_actions ppa
2478: where pai.locking_action_id = cp_prepayment_action_id
2479: and paa.assignment_action_id = pai.locked_action_id
2480: and ppa.payroll_action_id = paa.payroll_action_id
2481: and ppa.action_type in ('R', 'Q', 'B')
2489: cp_prepayment_action_id in number,
2490: cp_assignment_id in number) is
2491: select paa.assignment_action_id, paa.payroll_action_id,
2492: ppa.action_type
2493: from pay_payroll_actions ppa,
2494: pay_assignment_actions paa,
2495: pay_action_interlocks pai
2496: where pai.locking_action_Id = cp_prepayment_action_id
2497: and pai.locked_action_id = paa.assignment_action_id
2501: order by paa.assignment_action_id desc;
2502:
2503: cursor c_pymt_eff_date(cp_prepayment_action_id in number) is
2504: select effective_date
2505: from pay_payroll_actions ppa,
2506: pay_assignment_actions paa
2507: where ppa.payroll_action_id = paa.payroll_action_id
2508: and paa.assignment_action_id = cp_prepayment_action_id;
2509:
2529: cursor c_master_run_action_type(
2530: cp_prepayment_action_id in number,
2531: cp_assignment_id in number) is
2532: select distinct ppa.action_type
2533: from pay_payroll_actions ppa,
2534: pay_assignment_actions paa,
2535: pay_action_interlocks pai
2536: where pai.locking_action_Id = cp_prepayment_action_id
2537: and pai.locked_action_id = paa.assignment_action_id
3093: ''V'', nvl(ppa.future_process_mode, ''Y''). Bug#3498653 */
3094: lv_sql_string :=
3095: 'select distinct paa.assignment_id
3096: from pay_assignment_actions paa,
3097: pay_payroll_actions ppa
3098: where ppa.business_group_id = ''' || ln_business_group_id || '''
3099: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
3100: fnd_date.date_to_canonical(ld_start_date) || ''')
3101: and fnd_date.canonical_to_date(''' ||
3113: and not exists
3114: (select ''x''
3115: from pay_action_interlocks pai,
3116: pay_assignment_actions paa1,
3117: pay_payroll_actions ppa1
3118: where pai.locked_action_id = paa.assignment_action_id
3119: and paa1.assignment_action_id = pai.locking_action_id
3120: and ppa1.payroll_action_id = paa1.payroll_action_id
3121: and ppa1.action_type =''X''
3177: ppa.date_earned,
3178: ppa.action_type,
3179: paa.assignment_action_id,
3180: paa.payroll_action_id
3181: from pay_payroll_actions ppa,
3182: pay_assignment_actions paa
3183: where paa.assignment_id between cp_start_assignment_id
3184: and cp_end_assignment_id
3185: and ppa.consolidation_set_id = cp_cons_set_id
3198: and not exists
3199: (select 'x'
3200: from pay_action_interlocks pai1,
3201: pay_assignment_actions paa1,
3202: pay_payroll_actions ppa1
3203: where pai1.locked_action_id = paa.assignment_action_id
3204: and paa1.assignment_action_id = pai1.locking_action_id
3205: and ppa1.payroll_action_id = paa1.payroll_action_id
3206: and ppa1.action_type ='X'
3208: order by 1,2,3,4,5;
3209:
3210: cursor c_master_action(cp_prepayment_action_id number) is
3211: select max(paa.assignment_action_id)
3212: from pay_payroll_actions ppa,
3213: pay_assignment_actions paa,
3214: pay_action_interlocks pai
3215: where pai.locking_action_Id = cp_prepayment_action_id
3216: and pai.locked_action_id = paa.assignment_action_id
3435:
3436: cursor cur_reporting_level(p_pactid in number) is
3437: select org_information1
3438: from hr_organization_information hoi,
3439: pay_payroll_actions ppa
3440: where ppa.payroll_action_id = p_pactid
3441: and hoi.organization_id = ppa.business_group_id
3442: and hoi.org_information_context = 'Payroll Archiver Level';
3443: