[Home] [Help]
351: 'TRANSFER_CONSOLIDATION_SET_ID=') - 1 )
352: - (instr(legislative_parameters,
353: 'TRANSFER_PAYROLL_ID=')
354: + length('TRANSFER_PAYROLL_ID='))))))
355: from pay_payroll_actions
356: where payroll_action_id = cp_payroll_action_id;
357:
358: ld_end_date DATE;
359: ld_start_date DATE;
601: cursor c_last_payment_info(cp_assignment_id in number
602: ,cp_curr_pymt_eff_date in date) is
603:
604: select ppa.effective_date, paa.assignment_action_id
605: from pay_payroll_actions ppa,
606: pay_assignment_actions paa
607: where paa.assignment_id = p_assignment_id
608: and ppa.payroll_action_id = paa.payroll_action_id
609: and ppa.action_type in ('U','P')
609: and ppa.action_type in ('U','P')
610: and ppa.effective_date < p_curr_pymt_eff_date
611: and ppa.effective_date in
612: ( select max(ppa1.effective_date)
613: from pay_payroll_actions ppa1,
614: pay_assignment_actions paa1
615: where ppa1.payroll_action_id = paa1.payroll_action_id
616: and ppa1.action_type in ('U','P')
617: and paa1.assignment_id = p_assignment_id
727: and exists (
728: select ''
729: from pay_run_types_f prt,
730: pay_assignment_actions paa_run,
731: pay_payroll_actions ppa_run
732: where paa_run.assignment_action_id
733: = ppp.source_action_id
734: and paa_run.payroll_action_id
735: = ppa_run.payroll_action_id
820: pay_run_result_values prrv,
821: pay_input_values_f piv_pay,
822: pay_element_types_f pet,
823: pay_run_results prr,
824: pay_payroll_actions run_ppa,
825: pay_assignment_actions run_paa,
826: pay_action_interlocks pai,
827: pay_pre_payments ppp
828: WHERE prrv.result_value = to_char(cp_amount)
1158: ,cp_sepchk_run_type in number) is
1159: select paa.assignment_action_id
1160: from pay_assignment_actions paa,
1161: pay_action_interlocks pai,
1162: pay_payroll_actions ppa
1163: where pai.locking_action_id = cp_prepayment_action_id
1164: and paa.assignment_action_id = pai.locked_action_id
1165: and paa.assignment_id = cp_assignment_id
1166: and ppa.payroll_action_id = paa.payroll_action_id
1181: ,cp_sepchk_run_type in number) is
1182: select paa.assignment_action_id
1183: from pay_assignment_actions paa,
1184: pay_action_interlocks pai,
1185: pay_payroll_actions ppa
1186: where pai.locking_action_id = cp_prepayment_action_id
1187: and paa.assignment_action_id = pai.locked_action_id
1188: and paa.assignment_id = cp_assignment_id
1189: and paa.tax_unit_id = cp_tax_unit_id
1201: select ptp.time_period_id,
1202: ppa.date_earned,
1203: ppa.effective_date
1204: from pay_assignment_actions paa,
1205: pay_payroll_actions ppa,
1206: per_time_periods ptp
1207: where paa.assignment_action_id = cp_run_assignment_action
1208: and ppa.payroll_action_id = paa.payroll_action_id
1209: and ptp.payroll_id = ppa.payroll_id
1633: cursor c_get_pp_actid_of_sepchk(cp_source_action_id number) is
1634: select paa.assignment_action_id
1635: from pay_action_interlocks pai
1636: ,pay_assignment_actions paa
1637: ,pay_payroll_actions ppa
1638: where pai.locked_action_id = cp_source_action_id
1639: and paa.assignment_action_id = pai.locking_action_id
1640: and paa.source_action_id is not null
1641: and ppa.payroll_action_id = paa.payroll_action_id
1647: ,cp_assignment_id number) is
1648: select paa.assignment_action_id,ppa_run.action_type
1649: from pay_assignment_actions paa
1650: ,pay_action_interlocks pai
1651: ,pay_payroll_actions ppa_run
1652: where pai.locking_action_id = cp_pp_asg_act_id
1653: and paa.assignment_action_id = pai.locked_action_id
1654: and paa.assignment_id = cp_assignment_id
1655: and paa.source_action_id is null
1973: cursor c_get_pp_actid_of_sepchk(cp_source_action_id number) is
1974: select paa.assignment_action_id
1975: from pay_action_interlocks pai
1976: ,pay_assignment_actions paa
1977: ,pay_payroll_actions ppa
1978: where pai.locked_action_id = cp_source_action_id
1979: and paa.assignment_action_id = pai.locking_action_id
1980: and paa.source_action_id is not null
1981: and ppa.payroll_action_id = paa.payroll_action_id
2691: paa.assignment_id,
2692: paa.tax_unit_id,
2693: paa.assignment_action_id,
2694: ppp.source_action_id
2695: from pay_payroll_actions ppa
2696: ,pay_assignment_actions paa
2697: ,pay_pre_payments ppp
2698: ,pay_org_payment_methods popm
2699: where ppa.consolidation_set_id
2984: cursor c_assignment_run (cp_prepayment_action_id in number) is
2985: select distinct paa.assignment_id
2986: from pay_action_interlocks pai,
2987: pay_assignment_actions paa,
2988: pay_payroll_actions ppa
2989: where pai.locking_action_id = cp_prepayment_action_id
2990: and paa.assignment_action_id = pai.locked_action_id
2991: and ppa.payroll_action_id = paa.payroll_action_id
2992: and ppa.action_type in ('R', 'Q', 'B')
3000: cp_prepayment_action_id in number,
3001: cp_assignment_id in number) is
3002: select paa.assignment_action_id, paa.payroll_action_id,
3003: ppa.action_type
3004: from pay_payroll_actions ppa,
3005: pay_assignment_actions paa,
3006: pay_action_interlocks pai
3007: where pai.locking_action_Id = cp_prepayment_action_id
3008: and pai.locked_action_id = paa.assignment_action_id
3012: order by paa.assignment_action_id desc;
3013:
3014: cursor c_pymt_eff_date(cp_prepayment_action_id in number) is
3015: select effective_date
3016: from pay_payroll_actions ppa,
3017: pay_assignment_actions paa
3018: where ppa.payroll_action_id = paa.payroll_action_id
3019: and paa.assignment_action_id = cp_prepayment_action_id;
3020:
3040: cursor c_master_run_action_type(
3041: cp_prepayment_action_id in number,
3042: cp_assignment_id in number) is
3043: select distinct ppa.action_type
3044: from pay_payroll_actions ppa,
3045: pay_assignment_actions paa,
3046: pay_action_interlocks pai
3047: where pai.locking_action_Id = cp_prepayment_action_id
3048: and pai.locked_action_id = paa.assignment_action_id
3604: ''V'', nvl(ppa.future_process_mode, ''Y''). Bug#3498653 */
3605: lv_sql_string :=
3606: 'select distinct paa.assignment_id
3607: from pay_assignment_actions paa,
3608: pay_payroll_actions ppa
3609: where ppa.business_group_id = ''' || ln_business_group_id || '''
3610: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
3611: fnd_date.date_to_canonical(ld_start_date) || ''')
3612: and fnd_date.canonical_to_date(''' ||
3624: and not exists
3625: (select ''x''
3626: from pay_action_interlocks pai,
3627: pay_assignment_actions paa1,
3628: pay_payroll_actions ppa1
3629: where pai.locked_action_id = paa.assignment_action_id
3630: and paa1.assignment_action_id = pai.locking_action_id
3631: and ppa1.payroll_action_id = paa1.payroll_action_id
3632: and ppa1.action_type =''X''
3688: ppa.date_earned,
3689: ppa.action_type,
3690: paa.assignment_action_id,
3691: paa.payroll_action_id
3692: from pay_payroll_actions ppa,
3693: pay_assignment_actions paa
3694: where paa.assignment_id between cp_start_assignment_id
3695: and cp_end_assignment_id
3696: and ppa.consolidation_set_id = cp_cons_set_id
3709: and not exists
3710: (select 'x'
3711: from pay_action_interlocks pai1,
3712: pay_assignment_actions paa1,
3713: pay_payroll_actions ppa1
3714: where pai1.locked_action_id = paa.assignment_action_id
3715: and paa1.assignment_action_id = pai1.locking_action_id
3716: and ppa1.payroll_action_id = paa1.payroll_action_id
3717: and ppa1.action_type ='X'
3719: order by 1,2,3,4,5;
3720:
3721: cursor c_master_action(cp_prepayment_action_id number) is
3722: select max(paa.assignment_action_id)
3723: from pay_payroll_actions ppa,
3724: pay_assignment_actions paa,
3725: pay_action_interlocks pai
3726: where pai.locking_action_Id = cp_prepayment_action_id
3727: and pai.locked_action_id = paa.assignment_action_id
3946:
3947: cursor cur_reporting_level(p_pactid in number) is
3948: select org_information1
3949: from hr_organization_information hoi,
3950: pay_payroll_actions ppa
3951: where ppa.payroll_action_id = p_pactid
3952: and hoi.organization_id = ppa.business_group_id
3953: and hoi.org_information_context = 'Payroll Archiver Level';
3954: