[Home] [Help]
388: 'TRANSFER_CONSOLIDATION_SET_ID=') - 1 )
389: - (instr(legislative_parameters,
390: 'TRANSFER_PAYROLL_ID=')
391: + length('TRANSFER_PAYROLL_ID='))))))
392: from pay_payroll_actions
393: where payroll_action_id = cp_payroll_action_id;
394:
395: ld_end_date DATE;
396: ld_start_date DATE;
535:
536: lv_sql_string :=
537: 'select distinct paf.person_id
538: from pay_assignment_actions paa,
539: pay_payroll_actions ppa,
540: per_assignments_f paf
541: where ppa.business_group_id = ''' || ln_business_group_id || '''
542: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
543: fnd_date.date_to_canonical(ld_start_date) || ''')
559: (select /*+ ORDERED */
560: 1
561: from pay_action_interlocks pai,
562: pay_assignment_actions paa1,
563: pay_payroll_actions ppa1
564: where pai.locked_action_id = paa.assignment_action_id
565: and paa1.assignment_action_id = pai.locking_action_id
566: and ppa1.payroll_action_id = paa1.payroll_action_id
567: and ppa1.action_type =''X''
599: ,cp_start_date in date
600: ,cp_end_date in date
601: ) is
602: select /*+ INDEX(PAF PER_ASSIGNMENTS_F_N12)
603: INDEX(PPA PAY_PAYROLL_ACTIONS_N50)
604: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51) */
605: paa.assignment_id,
606: paa.tax_unit_id,
607: ppa.effective_date,
608: ppa.date_earned,
609: ppa.action_type,
610: paa.assignment_action_id,
611: paa.payroll_action_id
612: from pay_payroll_actions ppa,
613: pay_assignment_actions paa,
614: per_assignments_f paf
615: where paf.person_id between cp_start_person_id
616: and cp_end_person_id
632: and not exists
633: (select 'x'
634: from pay_action_interlocks pai1,
635: pay_assignment_actions paa1,
636: pay_payroll_actions ppa1
637: where pai1.locked_action_id = paa.assignment_action_id
638: and paa1.assignment_action_id = pai1.locking_action_id
639: and ppa1.payroll_action_id = paa1.payroll_action_id
640: and ppa1.action_type ='X'
651: ,cp_end_date in date
652: ) is
653: select /*+ INDEX(PPR PAY_POPULATION_RANGES_N4)
654: INDEX(PAF PER_ASSIGNMENTS_F_N12)
655: INDEX(PPA PAY_PAYROLL_ACTIONS_N50)
656: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51) */
657: paa.assignment_id,
658: paa.tax_unit_id,
659: ppa.effective_date,
660: ppa.date_earned,
661: ppa.action_type,
662: paa.assignment_action_id,
663: paa.payroll_action_id
664: from pay_payroll_actions ppa,
665: pay_assignment_actions paa,
666: per_assignments_f paf,
667: pay_population_ranges ppr
668: where ppr.payroll_action_id = cp_payroll_action_id
686: and not exists
687: (select 'x'
688: from pay_action_interlocks pai1,
689: pay_assignment_actions paa1,
690: pay_payroll_actions ppa1
691: where pai1.locked_action_id = paa.assignment_action_id
692: and paa1.assignment_action_id = pai1.locking_action_id
693: and ppa1.payroll_action_id = paa1.payroll_action_id
694: and ppa1.action_type ='X'
696: order by 1,2,3,5,6;
697:
698: cursor c_master_action(cp_prepayment_action_id number) is
699: select max(paa.assignment_action_id)
700: from pay_payroll_actions ppa,
701: pay_assignment_actions paa,
702: pay_action_interlocks pai
703: where pai.locking_action_Id = cp_prepayment_action_id
704: and paa.assignment_action_id = pai.locked_action_id
950: ln_step NUMBER;
951:
952: cursor c_asg_actions (cp_payroll_action_id in number) is
953: select ppa.effective_date
954: from pay_payroll_actions ppa
955: where ppa.payroll_action_id = cp_payroll_action_id;
956:
957: cursor c_get_balance_type_id (cp_balance_name in varchar2) is
958: select balance_type_id
5188: ,cp_sepchk_run_type in number) is
5189: select paa.assignment_action_id
5190: from pay_assignment_actions paa,
5191: pay_action_interlocks pai,
5192: pay_payroll_actions ppa
5193: where pai.locking_action_id = cp_prepayment_action_id
5194: and paa.assignment_action_id = pai.locked_action_id
5195: and paa.assignment_id = cp_assignment_id
5196: and ppa.payroll_action_id = paa.payroll_action_id
5204: nvl(ppa.date_earned,ppa.effective_date),
5205: --bug 7379102
5206: ppa.effective_date
5207: from pay_assignment_actions paa,
5208: pay_payroll_actions ppa,
5209: per_time_periods ptp
5210: where paa.assignment_action_id = cp_run_assignment_action
5211: and ppa.payroll_action_id = paa.payroll_action_id
5212: and ptp.payroll_id = ppa.payroll_id
5601: cursor c_assignment_run (cp_prepayment_action_id in number) is
5602: select distinct paa.assignment_id
5603: from pay_action_interlocks pai,
5604: pay_assignment_actions paa,
5605: pay_payroll_actions ppa
5606: where pai.locking_action_id = cp_prepayment_action_id
5607: and paa.assignment_action_id = pai.locked_action_id
5608: and ppa.payroll_action_id = paa.payroll_action_id
5609: and ppa.action_type in ('R', 'Q', 'B')
5615: cp_prepayment_action_id in number,
5616: cp_assignment_id in number) is
5617: select paa.assignment_action_id, paa.payroll_action_id,
5618: ppa.action_type
5619: from pay_payroll_actions ppa,
5620: pay_assignment_actions paa,
5621: pay_action_interlocks pai
5622: where pai.locking_action_id = cp_prepayment_action_id
5623: and pai.locked_action_id = paa.assignment_action_id
5627: order by paa.assignment_action_id desc;
5628:
5629: cursor c_pymt_eff_date(cp_prepayment_action_id in number) is
5630: select ppa.effective_date
5631: from pay_payroll_actions ppa,
5632: pay_assignment_actions paa
5633: where ppa.payroll_action_id = paa.payroll_action_id
5634: and paa.assignment_action_id = cp_prepayment_action_id;
5635:
5690: paf1.assignment_id,
5691: paa.assignment_action_id
5692: from per_all_assignments_f paf1
5693: ,pay_assignment_actions paa
5694: ,pay_payroll_actions ppa
5695: where paf1.person_id = (select /*+ PUSH_SUBQ */ person_id
5696: from per_all_assignments_f START_ASS
5697: where START_ASS.assignment_id = cp_assignment_id
5698: and rownum = 1)