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_EAS dependencies on PER_ALL_ASSIGNMENTS_F

Line 269: from per_all_assignments_f paa,

265: l_end_date date;
266:
267: cursor c_get_employee_flag(asg_id number) is
268: select distinct pap.effective_start_date , pap.effective_end_date , pap.current_employee_flag current_employee_flag
269: from per_all_assignments_f paa,
270: per_all_people_f pap,
271: per_periods_of_service serv
272: where paa.assignment_id = asg_id
273: and pap.person_id = paa.person_id

Line 296: per_all_assignments_f paa,

292: current_employee_flag,
293: pap.effective_start_date effective_start_date,
294: serv.actual_termination_date actual_termination_date
295: FROM pay_assignment_actions act,
296: per_all_assignments_f paa,
297: per_all_people_f pap,
298: per_periods_of_service serv,
299: per_assignment_status_types past
300: where act.assignment_action_id = p_assactid

Line 329: per_all_assignments_f paa,

325: current_employee_flag,
326: pap.effective_start_date effective_start_date,
327: serv.actual_termination_date actual_termination_date
328: FROM pay_assignment_actions act,
329: per_all_assignments_f paa,
330: per_all_people_f pap,
331: per_periods_of_service serv,
332: per_assignment_status_types past
333: where act.assignment_action_id = p_assactid

Line 472: ' from per_all_assignments_f where assignment_id = :assignment_id and ASS_ATTRIBUTE_CATEGORY = :l_context_name'||

468:
469: elsif l_source_name = 'PER_ASSIGNMENTS' THEN
470:
471: l_sqlstr := 'select ' || l_column_name ||
472: ' from per_all_assignments_f where assignment_id = :assignment_id and ASS_ATTRIBUTE_CATEGORY = :l_context_name'||
473: ' and '||p_effective_start_date||' between effective_start_date and effective_end_date' ;
474: begin
475: EXECUTE immediate l_sqlstr INTO l_expat_indicator USING p_assignment_id,l_context_name;
476:

Line 615: ' from per_all_assignments_f where assignment_id = :assignment_id and ASS_ATTRIBUTE_CATEGORY = :l_context_name'||

611:
612: elsif l_source_name = 'PER_ASSIGNMENTS' THEN
613:
614: l_sqlstr := 'select ' || l_column_name ||
615: ' from per_all_assignments_f where assignment_id = :assignment_id and ASS_ATTRIBUTE_CATEGORY = :l_context_name'||
616: ' and '||p_effective_start_date||' between effective_start_date and effective_end_date' ;
617: begin
618: EXECUTE immediate l_sqlstr INTO l_occ_pension_indicator USING p_assignment_id,l_context_name;
619:

Line 757: ' from per_all_assignments_f where assignment_id = :assignment_id and ASS_ATTRIBUTE_CATEGORY = :l_context_name'||

753:
754: elsif l_source_name = 'PER_ASSIGNMENTS' THEN
755:
756: l_sqlstr := 'select ' || l_column_name ||
757: ' from per_all_assignments_f where assignment_id = :assignment_id and ASS_ATTRIBUTE_CATEGORY = :l_context_name'||
758: ' and '||p_effective_start_date||' between effective_start_date and effective_end_date' ;
759:
760: begin
761: EXECUTE immediate l_sqlstr INTO l_pay_non_indiv_ind USING p_assignment_id,l_context_name;

Line 854: from per_all_assignments_f paaf

850:
851: cursor csr_get_asg_no is
852: select assignment_number,
853: paaf.effective_start_date
854: from per_all_assignments_f paaf
855: where assignment_id = p_person_rec.assignment_id
856: and paaf.effective_start_date =
857: (select max(paaf1.effective_start_date)
858: from per_all_assignments_f paaf1 where

Line 858: from per_all_assignments_f paaf1 where

854: from per_all_assignments_f paaf
855: where assignment_id = p_person_rec.assignment_id
856: and paaf.effective_start_date =
857: (select max(paaf1.effective_start_date)
858: from per_all_assignments_f paaf1 where
859: paaf1.assignment_id = paaf.assignment_id
860: and paaf1.assignment_type = 'E'
861: and paaf1.effective_start_date <= l_eff_date
862: );

Line 912: per_all_assignments_f paaf,

908: select min(paaf.EFFECTIVE_START_DATE) , max(paaf1.EFFECTIVE_END_DATE) , max(paaf.assignment_id) l_prev_asg_id
909: from
910: per_all_people_f peo,
911: per_all_people_f peo1,
912: per_all_assignments_f paaf,
913: per_all_assignments_f paaf1,
914: per_assignment_status_types past,
915: per_assignment_status_types past1,
916: pay_all_payrolls_f papf ,

Line 913: per_all_assignments_f paaf1,

909: from
910: per_all_people_f peo,
911: per_all_people_f peo1,
912: per_all_assignments_f paaf,
913: per_all_assignments_f paaf1,
914: per_assignment_status_types past,
915: per_assignment_status_types past1,
916: pay_all_payrolls_f papf ,
917: pay_all_payrolls_f papf1,

Line 940: (select '1' from per_all_assignments_f paafs,

936: and upper(p_tax_ref) = upper(flex.segment1)
937: and paaf.EFFECTIVE_END_DATE = paaf1.EFFECTIVE_START_DATE - 1
938: and paaf.assignment_id <> paaf1.assignment_id
939: and exists
940: (select '1' from per_all_assignments_f paafs,
941: per_assignment_status_types pasts
942: where paafs.assignment_id = paaf.assignment_id
943: and paafs.effective_start_date = paaf1.effective_start_date
944: and paafs.assignment_status_type_id = pasts.assignment_status_type_id

Line 952: per_all_assignments_f paaf,

948:
949: cursor csr_get_start_end_dates(p_eff_date date,p_tax_ref varchar2) is
950: select paaf.effective_start_date,paaf.effective_end_date
951: from
952: per_all_assignments_f paaf,
953: pay_all_payrolls_f papf ,
954: hr_soft_coding_keyflex flex,
955: per_assignment_status_types past
956: where

Line 964: (select max(paaf1.effective_start_date) from per_all_assignments_f paaf1,per_assignment_status_types past1

960: and upper(p_tax_ref) = upper(flex.segment1)
961: and paaf.assignment_status_type_id = past.assignment_status_type_id
962: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
963: and paaf.effective_start_date =
964: (select max(paaf1.effective_start_date) from per_all_assignments_f paaf1,per_assignment_status_types past1
965: where paaf1.assignment_id = paaf.assignment_id
966: and paaf1.assignment_type = 'E'
967: and paaf1.assignment_status_type_id = past1.assignment_status_type_id
968: and past1.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 2285: 'from per_all_assignments_f paaf, '||

2281: IF (l_payroll_id is not null) THEN
2282:
2283: IF ((l_employee_number is null) and (l_assignment_set is null)) THEN
2284: sqlstr := 'select distinct PERSON_ID '||
2285: 'from per_all_assignments_f paaf, '||
2286: 'pay_payroll_actions ppa '||
2287: 'where ppa.payroll_action_id = :payroll_action_id '||
2288: 'and ppa.business_group_id = paaf.business_group_id '||
2289: ' and paaf.PAYROLL_ID = ' ||''''||l_payroll_id||''''||

Line 2296: 'per_all_assignments_f paaf, '||

2292:
2293: IF (l_employee_number is not null ) THEN
2294: sqlstr := 'select distinct ppf.person_id '||
2295: 'from per_all_people_f ppf, '||
2296: 'per_all_assignments_f paaf, '||
2297: 'pay_payroll_actions ppa '||
2298: 'where ppa.payroll_action_id = :payroll_action_id '||
2299: ' and paaf.person_id=ppf.person_id '||
2300: 'and ppa.business_group_id = ppf.business_group_id '||

Line 2390: per_all_assignments_f asg,

2386: cursor csr_asg_active is
2387: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,trim(pap.per_information10) per_agg_flag,
2388: pap.person_id person_id,past.per_system_status status
2389: from per_all_people_f pap,
2390: per_all_assignments_f asg,
2391: per_assignment_status_types past,
2392: per_periods_of_service serv,
2393: pay_all_payrolls_f pay,
2394: hr_soft_coding_keyflex sck,

Line 2416: from per_all_assignments_f asg2

2412: and nvl(l_unique_part_id,substr(sck.segment10,1,12)) = substr(sck.segment10,1,12)
2413: --and l_effective_date between asg.effective_start_date and asg.effective_end_date
2414: and asg.effective_start_date =
2415: ( select max(asg2.effective_start_date)
2416: from per_all_assignments_f asg2
2417: where asg2.assignment_id = asg.assignment_id
2418: and asg2.assignment_type = 'E'
2419: and asg2.effective_start_date <= l_effective_date
2420: )

Line 2430: per_all_assignments_f asg,

2426: cursor csr_asg_terminated is
2427: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,
2428: pap.person_id person_id, serv.actual_termination_date actual_termination_date
2429: from per_all_people_f pap,
2430: per_all_assignments_f asg,
2431: per_periods_of_service serv,
2432: pay_all_payrolls_f pay,
2433: hr_soft_coding_keyflex sck,
2434: hr_organization_information org

Line 2459: from per_all_assignments_f asg2

2455: and pap2.effective_start_date <= l_effective_date
2456: )
2457: and asg.effective_start_date =
2458: ( select max(asg2.effective_start_date)
2459: from per_all_assignments_f asg2
2460: where asg2.assignment_id = asg.assignment_id
2461: and asg2.assignment_type = 'E'
2462: and asg2.effective_start_date <= l_effective_date
2463: )

Line 2479: per_all_assignments_f paaf,

2475:
2476: cursor csr_find_next_asg(p_person_id number,p_assignment_id number) is
2477: select paaf.assignment_id
2478: from per_all_people_f peo,
2479: per_all_assignments_f paaf,
2480: per_all_assignments_f paaf1,
2481: per_assignment_status_types past,
2482: per_assignment_status_types past1,
2483: pay_all_payrolls_f papf ,

Line 2480: per_all_assignments_f paaf1,

2476: cursor csr_find_next_asg(p_person_id number,p_assignment_id number) is
2477: select paaf.assignment_id
2478: from per_all_people_f peo,
2479: per_all_assignments_f paaf,
2480: per_all_assignments_f paaf1,
2481: per_assignment_status_types past,
2482: per_assignment_status_types past1,
2483: pay_all_payrolls_f papf ,
2484: hr_soft_coding_keyflex flex

Line 2501: from per_all_assignments_f paaf ,

2497: and paaf.effective_start_date = paaf1.effective_start_date;
2498:
2499: cursor csr_get_terminated_date(p_asg_id number) is
2500: select max(effective_end_date)
2501: from per_all_assignments_f paaf ,
2502: per_assignment_status_types past
2503: where assignment_id = p_asg_id
2504: --and paaf.assignment_status_type_id in ( 1,2)
2505: and paaf.assignment_status_type_id = past.assignment_status_type_id

Line 2714: per_all_assignments_f asg,

2710: cursor csr_asg is
2711: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,trim(pap.per_information10) per_agg_flag,
2712: pap.person_id person_id,asg.effective_start_date effective_start_date
2713: from per_all_people_f pap,
2714: per_all_assignments_f asg,
2715: per_periods_of_service serv,
2716: pay_all_payrolls_f pay,
2717: hr_soft_coding_keyflex sck,
2718: per_people_extra_info ppei

Line 3003: l_assignment_number per_all_assignments_f.assignment_number%type;

2999: l_archive_addr boolean;
3000: l_archive_type VARCHAR2(20);
3001: l_archive_asg boolean;
3002: l_primary_flag varchar2(1);
3003: l_assignment_number per_all_assignments_f.assignment_number%type;
3004: l_assignment_id per_all_assignments_f.assignment_id%type;
3005: l_eas_etext_asg_flag varchar2(1);
3006: l_per_addr_val_flag varchar2(1);
3007: l_eas_val_err boolean := False;

Line 3004: l_assignment_id per_all_assignments_f.assignment_id%type;

3000: l_archive_type VARCHAR2(20);
3001: l_archive_asg boolean;
3002: l_primary_flag varchar2(1);
3003: l_assignment_number per_all_assignments_f.assignment_number%type;
3004: l_assignment_id per_all_assignments_f.assignment_id%type;
3005: l_eas_etext_asg_flag varchar2(1);
3006: l_per_addr_val_flag varchar2(1);
3007: l_eas_val_err boolean := False;
3008: l_personaddr_val_err boolean := False;

Line 3046: from per_all_assignments_f paaf

3042: paa.payroll_action_id = p_pact_id
3043: and paa.action_status = 'C'
3044: and paa.assignment_id in(
3045: select assignment_id
3046: from per_all_assignments_f paaf
3047: where paaf.person_id = p_person_id
3048: and paaf.business_group_id = p_business_group_id
3049: and paaf.effective_start_date =
3050: (select max(paaf1.effective_start_date)

Line 3051: from per_all_assignments_f paaf1 where

3047: where paaf.person_id = p_person_id
3048: and paaf.business_group_id = p_business_group_id
3049: and paaf.effective_start_date =
3050: (select max(paaf1.effective_start_date)
3051: from per_all_assignments_f paaf1 where
3052: paaf1.assignment_id = paaf.assignment_id
3053: and paaf1.assignment_type = 'E'
3054: and paaf1.effective_start_date <= p_effective_date));
3055:

Line 3062: per_all_assignments_f asg1,

3058: is
3059: select distinct ppa.payroll_action_id
3060: from pay_payroll_actions ppa,
3061: pay_assignment_actions paa,
3062: per_all_assignments_f asg1,
3063: per_all_assignments_f asg2
3064: where asg1.assignment_id = p_assignment_id
3065: and asg1.person_id = asg2.person_id
3066: and asg1.assignment_id <> asg2.assignment_id

Line 3063: per_all_assignments_f asg2

3059: select distinct ppa.payroll_action_id
3060: from pay_payroll_actions ppa,
3061: pay_assignment_actions paa,
3062: per_all_assignments_f asg1,
3063: per_all_assignments_f asg2
3064: where asg1.assignment_id = p_assignment_id
3065: and asg1.person_id = asg2.person_id
3066: and asg1.assignment_id <> asg2.assignment_id
3067: and asg1.business_group_id = p_business_group_id

Line 3077: from per_all_assignments_f paaf1 where

3073: and ppa.REPORT_TYPE='RTI_EAS_REP_13'
3074: and substr(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'TAX_REF'),1,20) = substr(p_tax_ref,1,20)
3075: and asg1.effective_start_date =
3076: (select max(paaf1.effective_start_date)
3077: from per_all_assignments_f paaf1 where
3078: paaf1.assignment_id = asg1.assignment_id
3079: and paaf1.assignment_type = 'E'
3080: and paaf1.effective_start_date <= p_effective_date)
3081: and asg2.effective_start_date =

Line 3083: from per_all_assignments_f paaf2 where

3079: and paaf1.assignment_type = 'E'
3080: and paaf1.effective_start_date <= p_effective_date)
3081: and asg2.effective_start_date =
3082: (select max(paaf2.effective_start_date)
3083: from per_all_assignments_f paaf2 where
3084: paaf2.assignment_id = asg2.assignment_id
3085: and paaf2.assignment_type = 'E'
3086: and paaf2.effective_start_date <= p_effective_date);
3087:

Line 3092: from per_all_assignments_f asg,

3088:
3089: cursor fetch_all_paye_agg_asg(p_business_group_id number,p_tax_ref varchar2,p_person_id number,p_effective_date date)
3090: is
3091: select asg.assignment_id
3092: from per_all_assignments_f asg,
3093: pay_payrolls_f pay,
3094: hr_soft_coding_keyflex sck
3095: where asg.person_id = p_person_id
3096: and asg.business_group_id = p_business_group_id

Line 3103: from per_all_assignments_f paaf1 where

3099: and sck.SEGMENT1=p_tax_ref
3100: and p_effective_date between pay.EFFECTIVE_START_DATE and pay.EFFECTIVE_END_DATE
3101: and asg.effective_start_date =
3102: (select max(paaf1.effective_start_date)
3103: from per_all_assignments_f paaf1 where
3104: paaf1.assignment_id = asg.assignment_id
3105: and paaf1.assignment_type = 'E'
3106: and paaf1.effective_start_date <= p_effective_date);
3107:

Line 3635: , per_all_assignments_f paaf

3631: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
3632: , paaf.assignment_number
3633: from pay_payroll_actions ppa,
3634: pay_assignment_actions paa
3635: , per_all_assignments_f paaf
3636: where ppa.payroll_action_id = pactid -- pact_id
3637: and paa.payroll_action_id = ppa.payroll_action_id
3638: and paa.action_status = 'C'
3639: and paaf.assignment_id = paa.assignment_id

Line 3643: FROM per_all_assignments_f paaf2

3639: and paaf.assignment_id = paa.assignment_id
3640: and paaf.effective_start_date =
3641: (
3642: SELECT MAX(paaf2.effective_start_date)
3643: FROM per_all_assignments_f paaf2
3644: WHERE paaf2.assignment_id = paaf.assignment_id
3645: )
3646: ORDER BY
3647: paaf.assignment_number;

Line 3654: , per_all_assignments_f paaf

3650: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
3651: , paaf.assignment_number
3652: from pay_payroll_actions ppa,
3653: pay_assignment_actions paa
3654: , per_all_assignments_f paaf
3655: where ppa.payroll_action_id = pactid -- pact_id
3656: and paa.payroll_action_id = ppa.payroll_action_id
3657: and paa.action_status = 'E'
3658: and paaf.assignment_id = paa.assignment_id

Line 3662: FROM per_all_assignments_f paaf2

3658: and paaf.assignment_id = paa.assignment_id
3659: and paaf.effective_start_date =
3660: (
3661: SELECT MAX(paaf2.effective_start_date)
3662: FROM per_all_assignments_f paaf2
3663: WHERE paaf2.assignment_id = paaf.assignment_id
3664: )
3665: ORDER BY
3666: paaf.assignment_number;

Line 3708: from per_all_assignments_f paa,

3704: nvl(pap.employee_number,' ') employee_number,
3705: to_char(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
3706: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
3707: pap.person_id
3708: from per_all_assignments_f paa,
3709: per_assignment_status_types past,
3710: per_all_people_f pap
3711: ,pay_payroll_actions ppa
3712: where paa.person_id = pap.person_id

Line 3723: FROM per_all_assignments_f paa2

3719: AND paa.assignment_type = 'E'
3720: AND paa.effective_start_date =
3721: (
3722: SELECT MAX(paa2.effective_start_date)
3723: FROM per_all_assignments_f paa2
3724: WHERE paa2.assignment_id = paa.assignment_id
3725: AND paa2.effective_start_date <= p_eff_date
3726: )
3727: order by end_date desc;

Line 3740: from per_all_assignments_f paa,

3736: nvl(pap.employee_number,' ') employee_number,
3737: to_char(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
3738: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
3739: pap.person_id
3740: from per_all_assignments_f paa,
3741: per_assignment_status_types past,
3742: per_all_people_f pap
3743: where paa.person_id = pap.person_id
3744: and paa.assignment_id = c_assignment_id

Line 3964: per_all_assignments_f paaf

3960: cursor get_person_count is
3961: select count(distinct(paaf.person_id))
3962: from pay_payroll_actions ppa,
3963: pay_assignment_actions paa,
3964: per_all_assignments_f paaf
3965: where ppa.payroll_action_id = pactid -- pact_id
3966: and paa.payroll_action_id = ppa.payroll_action_id
3967: and paa.action_status = 'C'
3968: and paaf.assignment_id = paa.assignment_id;

Line 4217: per_all_assignments_f paaf,

4213: return date is
4214: l_eff_date date;
4215: cursor csr_get_start_date is
4216: select paaf.effective_start_date from
4217: per_all_assignments_f paaf,
4218: pay_all_payrolls_f papf ,
4219: hr_soft_coding_keyflex flex,
4220: per_assignment_status_types past
4221: where paaf.assignment_id = asg_id and paaf.effective_end_date = eff_date - 1

Line 4246: per_all_assignments_f paaf,

4242: l_eff_date date;
4243: cursor csr_get_end_date is
4244: select paaf.effective_end_date
4245: from
4246: per_all_assignments_f paaf,
4247: pay_all_payrolls_f papf ,
4248: hr_soft_coding_keyflex flex,
4249: per_assignment_status_types past
4250: where paaf.assignment_id = asg_id and paaf.effective_start_date = eff_date + 1