eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_P60 dependencies on PER_ALL_ASSIGNMENTS_F

Line 355: FROM per_all_assignments_f asg

351: CURSOR csr_asg_num
352: IS
353: SELECT asg.assignment_number,
354: asg.people_group_id
355: FROM per_all_assignments_f asg
356: WHERE asg.assignment_id = p_asg_id
357: AND sysdate BETWEEN asg.effective_start_date AND asg.effective_end_date;
358:
359:

Line 677: FROM per_all_assignments_f paaf,

673:
674: CURSOR get_asg_active_range(p_asg_id NUMBER, p_tax_ref VARCHAR2) IS
675: SELECT min(paaf.effective_start_date) min_active,
676: max(paaf.effective_end_date) max_active
677: FROM per_all_assignments_f paaf,
678: per_assignment_status_types past,
679: pay_all_payrolls_f papf,
680: hr_soft_coding_keyflex flex
681: WHERE paaf.assignment_id = p_asg_id

Line 698: per_all_assignments_f asg,

694: trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
695: trim(NVL(pap.per_information10,'N')) per_paye_agg_flag,
696: asg.assignment_number assignment_number
697: FROM per_all_people_f pap,
698: per_all_assignments_f asg,
699: pay_assignment_actions paa,
700: pay_payroll_actions ppa
701: WHERE paa.assignment_action_id = p_last_asg_action_id
702: AND ppa.payroll_action_id = paa.payroll_action_id

Line 718: per_all_assignments_f paaf,

714: to_number(SUBSTR(MAX(lpad(paa.action_sequence,15,'0')
715: || paa.assignment_action_id),16)) max_asg_act_id,
716: MAX(pact.effective_date) effective_date
717: FROM pay_assignment_actions paa,
718: per_all_assignments_f paaf,
719: pay_payroll_actions pact,
720: per_time_periods ptp
721: WHERE paa.assignment_id = paaf.assignment_id
722: AND paaf.person_id = p_person_id

Line 732: per_all_assignments_f paaf

728:
729: cursor csr_agg_oldest_asg is
730: select paa.assignment_action_id, paa.assignment_id
731: from pay_assignment_actions paa,
732: per_all_assignments_f paaf
733: where paaf.person_id = p_person_id
734: and paaf.assignment_id = paa.assignment_id
735: and paa.payroll_action_id = p_pactid
736: and paaf.effective_start_date =

Line 739: per_all_assignments_f paaf1

735: and paa.payroll_action_id = p_pactid
736: and paaf.effective_start_date =
737: (select min(paaf1.effective_start_date)
738: from pay_assignment_actions paa1,
739: per_all_assignments_f paaf1
740: where paaf1.person_id = p_person_id
741: and paaf1.assignment_id = paa1.assignment_id
742: and paa1.payroll_action_id = p_pactid
743: );

Line 748: per_all_assignments_f paaf,

744:
745: cursor csr_agg_primary_asg is
746: select paa.assignment_id
747: from pay_assignment_actions paa,
748: per_all_assignments_f paaf,
749: per_all_people_f papf
750: where paaf.person_id = p_person_id --41650 --
751: and paaf.assignment_id = paa.assignment_id
752: and paa.payroll_action_id = p_pactid --923889 --

Line 3243: per_all_assignments_f asg

3239: trim(asg.primary_flag) asg_primary_flag,
3240: trim(nvl(pap.per_information10,'N')) per_agg_flag,
3241: trim(nvl(pap.per_information9,'N')) ni_agg_flag
3242: FROM per_all_people_f pap,
3243: per_all_assignments_f asg
3244: WHERE asg.assignment_id = c_asg_id
3245: AND pap.person_id = asg.person_id
3246: AND asg.business_group_id = l_business_group_id
3247: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 3271: per_all_assignments_f paaf,

3267: trim(paaf.primary_flag) asg_primary_flag,
3268: trim(pap.per_information10) per_agg_flag,
3269: pap.person_id
3270: from per_all_people_f pap,
3271: per_all_assignments_f paaf,
3272: per_assignment_status_types past,
3273: pay_all_payrolls_f papf,
3274: hr_soft_coding_keyflex flex
3275: where pap.person_id between stperson and endperson

Line 3288: from per_all_assignments_f asg2

3284: and pap2.effective_start_date <= c_eff_date
3285: )
3286: and paaf.effective_start_date =
3287: ( select max(asg2.effective_start_date)
3288: from per_all_assignments_f asg2
3289: where asg2.assignment_id = paaf.assignment_id
3290: and asg2.assignment_type = 'E'
3291: and asg2.effective_start_date <= c_eff_date
3292: )

Line 3840: FROM per_all_assignments_f asg,

3836: asg.EFFECTIVE_START_DATE asg_eff_start_date,
3837: asg.person_id,
3838: asg.assignment_number,
3839: asg.payroll_id
3840: FROM per_all_assignments_f asg,
3841: pay_assignment_actions paa,
3842: pay_payroll_actions ppa
3843: WHERE paa.assignment_action_id = c_asg_act_id
3844: AND paa.assignment_id = asg.assignment_id

Line 3849: FROM per_all_assignments_f asg1

3845: AND ppa.payroll_action_id = paa.payroll_action_id
3846: AND (ppa.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
3847: OR asg.effective_end_date BETWEEN g_start_year AND g_end_year)
3848: AND asg.effective_start_date = (SELECT max(asg1.effective_start_date)
3849: FROM per_all_assignments_f asg1
3850: WHERE asg1.assignment_id = asg.assignment_id
3851: AND asg1.effective_start_date <= g_end_year);
3852: ---
3853:

Line 3862: per_all_assignments_f asg,

3858: trim(NVL(pap.per_information9,'N')) per_ni_agg_flag,
3859: trim(NVL(pap.per_information10,'N')) per_paye_agg_flag,
3860: asg.payroll_id payroll_id
3861: FROM per_all_people_f pap,
3862: per_all_assignments_f asg,
3863: pay_assignment_actions paa
3864: WHERE paa.assignment_action_id = c_asg_act_id
3865: AND paa.assignment_id = asg.assignment_id
3866: AND pap.person_id = asg.person_id

Line 3919: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei

3915: -- Cursor to fetch the RTI NI Reporting assignment for this person.
3916: cursor csr_get_ni_rpt_asg(c_asg_id number) is
3917: select
3918: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
3919: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei
3920: where paaf1.assignment_id = c_asg_id
3921: and paaf1.person_id = paaf2.person_id
3922: and paaf2.assignment_status_type_id in(select ASSIGNMENT_STATUS_TYPE_ID from per_assignment_status_types past where past.LEGISLATION_CODE is null and past.BUSINESS_GROUP_ID is null
3923: and PER_SYSTEM_STATUS = 'ACTIVE_ASSIGN')

Line 3942: per_all_assignments_f as1

3938: pay_payroll_actions appa2, --Prepayments
3939: pay_assignment_actions act, --Payroll Run
3940: pay_assignment_actions act1, --Prepayments
3941: pay_action_interlocks pai, --Prepayments
3942: per_all_assignments_f as1
3943: WHERE as1.person_id = p_person_id --45885
3944: AND appa.action_type IN ('R','Q') -- Payroll Run or Quickpay Run
3945: AND act.payroll_action_id = appa.payroll_action_id
3946: AND act.source_action_id IS NULL

Line 3966: per_all_assignments_f paaf,

3962: to_number(SUBSTR(MAX(lpad(paa.action_sequence,15,'0')
3963: || paa.assignment_action_id),16)) max_asg_act_id,
3964: MAX(pact.effective_date) effective_date
3965: FROM pay_assignment_actions paa,
3966: per_all_assignments_f paaf,
3967: pay_payroll_actions pact,
3968: per_time_periods ptp
3969: WHERE paa.assignment_id = paaf.assignment_id
3970: AND paaf.person_id = c_person_id --41650

Line 3981: FROM per_all_assignments_f asg,

3977: --Below cursor fetches the basic details of the current assignment
3978: CURSOR csr_asg_num(c_asg_act_id NUMBER, c_cur_last_effective_date date)
3979: IS
3980: SELECT asg.assignment_number
3981: FROM per_all_assignments_f asg,
3982: pay_assignment_actions paa
3983: WHERE paa.assignment_action_id = c_asg_act_id
3984: AND paa.assignment_id = asg.assignment_id
3985: AND c_cur_last_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 4732: FROM per_all_assignments_f paa,

4728: NVL(pap.employee_number,' ') employee_number,
4729: TO_CHAR(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
4730: paa.EFFECTIVE_END_DATE end_date,
4731: pap.person_id
4732: FROM per_all_assignments_f paa,
4733: per_assignment_status_types past,
4734: per_all_people_f pap
4735: WHERE paa.person_id = pap.person_id
4736: AND paa.assignment_id = c_assignment_id

Line 4747: from per_all_assignments_f asg2

4743: and pap2.effective_start_date <= l_effective_date
4744: )
4745: and paa.effective_start_date =
4746: ( select max(asg2.effective_start_date)
4747: from per_all_assignments_f asg2
4748: where asg2.assignment_id = paa.assignment_id
4749: and asg2.assignment_type = 'E'
4750: and ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
4751: and asg2.effective_start_date <= l_effective_date

Line 4903: per_all_assignments_f paaf

4899: IS
4900: SELECT COUNT(DISTINCT(paaf.person_id))
4901: FROM pay_payroll_actions ppa,
4902: pay_assignment_actions paa,
4903: per_all_assignments_f paaf
4904: WHERE ppa.payroll_action_id = pactid -- pact_id
4905: AND paa.payroll_action_id = ppa.payroll_action_id
4906: AND paa.action_status = 'C'
4907: AND paaf.assignment_id = paa.assignment_id;