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_EOY_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 759: pay_all_payrolls_f papf,

755: CURSOR get_first_active_start IS
756: SELECT max(paaf.effective_start_date) first_st_date, max(person_id) person_id
757: FROM per_all_assignments_f paaf,
758: per_assignment_status_types past,
759: pay_all_payrolls_f papf,
760: hr_soft_coding_keyflex flex
761: WHERE paaf.assignment_id = p_asg_id
762: AND paaf.assignment_status_type_id = past.assignment_status_type_id
763: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 777: pay_all_payrolls_f papf,

773: -- will not be able to return first Active/Susp Status date
774: CURSOR get_first_start IS
775: SELECT max(paaf.effective_start_date) first_st_date, max(person_id) person_id, max(period_of_service_id) pos_id
776: FROM per_all_assignments_f paaf,
777: pay_all_payrolls_f papf,
778: hr_soft_coding_keyflex flex
779: WHERE paaf.assignment_id = p_asg_id
780: AND paaf.payroll_id = papf.payroll_id
781: AND p_proll_eff_date BETWEEN papf.effective_start_date and papf.effective_end_date

Line 792: pay_all_payrolls_f papf,

788: CURSOR is_term_and_xfer IS
789: SELECT 'Y' term_and_xfer, flex.segment1 old_paye_ref
790: FROM per_all_assignments_f paaf,
791: per_assignment_status_types past,
792: pay_all_payrolls_f papf,
793: hr_soft_coding_keyflex flex
794: WHERE paaf.assignment_id = p_asg_id
795: AND paaf.assignment_status_type_id = past.assignment_status_type_id
796: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 811: pay_all_payrolls_f papf1,

807: CURSOR is_another_active_asg_xfer IS
808: SELECT 'Y'
809: FROM per_all_assignments_f paaf1,
810: per_assignment_status_types past1,
811: pay_all_payrolls_f papf1,
812: hr_soft_coding_keyflex flex1
813: WHERE paaf1.period_of_service_id = l_pos_id
814: AND paaf1.assignment_id <> p_asg_id
815: AND l_min_active BETWEEN paaf1.effective_start_date

Line 826: pay_all_payrolls_f papf2,

822: AND flex1.segment1 = p_tax_ref
823: AND EXISTS ( SELECT 1
824: FROM per_all_assignments_f paaf2,
825: per_assignment_status_types past2,
826: pay_all_payrolls_f papf2,
827: hr_soft_coding_keyflex flex2
828: WHERE paaf2.assignment_id = paaf1.assignment_id
829: AND l_min_active-1 BETWEEN paaf2.effective_start_date
830: AND paaf2.effective_end_date

Line 844: pay_all_payrolls_f papf,

840: CURSOR get_agg_min_start_date IS
841: SELECT min(paaf.effective_start_date) min_active
842: FROM per_all_assignments_f paaf,
843: per_assignment_status_types past,
844: pay_all_payrolls_f papf,
845: hr_soft_coding_keyflex flex
846: WHERE paaf.person_id = l_person_id
847: AND (l_min_active-1) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
848: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 960: pay_all_payrolls_f papf,

956: CURSOR get_last_active_end IS
957: SELECT max(paaf.effective_end_date) last_end_date, max(person_id) person_id
958: FROM per_all_assignments_f paaf,
959: per_assignment_status_types past,
960: pay_all_payrolls_f papf,
961: hr_soft_coding_keyflex flex
962: WHERE paaf.assignment_id = p_asg_id
963: AND paaf.assignment_status_type_id = past.assignment_status_type_id
964: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 978: pay_all_payrolls_f papf,

974: -- will not be able to return first Active/Susp Status date
975: CURSOR get_first_start IS
976: SELECT max(paaf.effective_start_date) first_st_date, max(person_id) person_id, max(period_of_service_id) pos_id
977: FROM per_all_assignments_f paaf,
978: pay_all_payrolls_f papf,
979: hr_soft_coding_keyflex flex
980: WHERE paaf.assignment_id = p_asg_id
981: AND paaf.payroll_id = papf.payroll_id
982: AND p_proll_eff_date BETWEEN papf.effective_start_date and papf.effective_end_date

Line 993: pay_all_payrolls_f papf,

989: CURSOR is_term_and_xfer IS
990: SELECT 'Y' term_and_xfer, flex.segment1 old_paye_ref
991: FROM per_all_assignments_f paaf,
992: per_assignment_status_types past,
993: pay_all_payrolls_f papf,
994: hr_soft_coding_keyflex flex
995: WHERE paaf.assignment_id = p_asg_id
996: AND paaf.assignment_status_type_id = past.assignment_status_type_id
997: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 1012: pay_all_payrolls_f papf1,

1008: CURSOR is_another_active_asg_xfer IS
1009: SELECT 'Y'
1010: FROM per_all_assignments_f paaf1,
1011: per_assignment_status_types past1,
1012: pay_all_payrolls_f papf1,
1013: hr_soft_coding_keyflex flex1
1014: WHERE paaf1.period_of_service_id = l_pos_id
1015: AND paaf1.assignment_id <> p_asg_id
1016: AND l_min_active BETWEEN paaf1.effective_start_date

Line 1027: pay_all_payrolls_f papf2,

1023: AND flex1.segment1 = p_tax_ref
1024: AND EXISTS ( SELECT 1
1025: FROM per_all_assignments_f paaf2,
1026: per_assignment_status_types past2,
1027: pay_all_payrolls_f papf2,
1028: hr_soft_coding_keyflex flex2
1029: WHERE paaf2.assignment_id = paaf1.assignment_id
1030: AND l_min_active-1 BETWEEN paaf2.effective_start_date
1031: AND paaf2.effective_end_date

Line 1045: pay_all_payrolls_f papf,

1041: CURSOR get_agg_max_end_date IS
1042: SELECT max(paaf.effective_end_date) max_active
1043: FROM per_all_assignments_f paaf,
1044: per_assignment_status_types past,
1045: pay_all_payrolls_f papf,
1046: hr_soft_coding_keyflex flex
1047: WHERE paaf.person_id = l_person_id
1048: AND (l_max_active+1) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1049: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 1349: FROM pay_all_payrolls_f p,

1345: flex.segment16 * 100 sap_compensation,
1346: flex.segment17 * 100 spp_recovered,
1347: flex.segment18 * 100 spp_compensation
1348: End 4011263 */
1349: FROM pay_all_payrolls_f p,
1350: hr_soft_coding_keyflex flex,
1351: hr_organization_information org
1352: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1353: AND org.org_information_context = 'Tax Details References'

Line 1362: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

1358: AND org.organization_id = p_bg_id
1359: AND p_end_year BETWEEN p.effective_start_date
1360: AND p.effective_end_date;
1361: --
1362: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
1363: --
1364: -- cursor to find a different PAYE Ref within a tax year on a given payroll
1365: CURSOR csr_another_paye_ref(p_payroll_id NUMBER,
1366: p_end_year DATE,

Line 1369: FROM pay_all_payrolls_f p,

1365: CURSOR csr_another_paye_ref(p_payroll_id NUMBER,
1366: p_end_year DATE,
1367: p_paye_ref VARCHAR2) IS
1368: SELECT flex.segment1
1369: FROM pay_all_payrolls_f p,
1370: hr_soft_coding_keyflex flex
1371: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id(+)
1372: AND p.payroll_id = p_payroll_id
1373: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)

Line 1857: pay_all_payrolls_f ppf,

1853: decode(per.per_information9,'Y','Y',NULL) multiple_asg_flag,
1854: rowidtochar(asg.ROWID) charrowid,
1855: 'N' tax_ref_xfer
1856: FROM per_all_assignments_f asg,
1857: pay_all_payrolls_f ppf,
1858: hr_soft_coding_keyflex flex,
1859: hr_organization_information org,
1860: per_all_people_f per
1861: WHERE asg.person_id BETWEEN stperson AND endperson

Line 1939: ,pay_all_payrolls_f NROLL

1935: FROM
1936: per_all_people_f per
1937: ,per_all_assignments_f PASS
1938: ,per_all_assignments_f ASS
1939: ,pay_all_payrolls_f NROLL
1940: ,hr_soft_coding_keyflex FLEX
1941: ,pay_all_payrolls_f PROLL
1942: ,hr_soft_coding_keyflex pflex
1943: WHERE NROLL.payroll_id = ASS.payroll_id

Line 1941: ,pay_all_payrolls_f PROLL

1937: ,per_all_assignments_f PASS
1938: ,per_all_assignments_f ASS
1939: ,pay_all_payrolls_f NROLL
1940: ,hr_soft_coding_keyflex FLEX
1941: ,pay_all_payrolls_f PROLL
1942: ,hr_soft_coding_keyflex pflex
1943: WHERE NROLL.payroll_id = ASS.payroll_id
1944: AND ASS.effective_start_date between
1945: NROLL.effective_start_date and NROLL.effective_end_date

Line 2255: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

2251: l_payroll_period_type VARCHAR2(30);
2252: l_payroll_max_period_number NUMBER;
2253: l_payroll_tax_ref VARCHAR2(10);
2254: l_payroll_tax_dist VARCHAR2(10);
2255: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
2256: l_number_per_fiscal_yr NUMBER;
2257: --
2258: -- get the defined balance id for specified balance and dimension
2259: cursor get_defined_balance_id

Line 3137: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

3133: l_payroll_max_period_number NUMBER;
3134: l_payroll_tax_ref VARCHAR2(10);
3135: l_payroll_tax_dist VARCHAR2(3);
3136: --
3137: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
3138: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3139: l_person_id per_all_people_f.person_id%TYPE;
3140: l_organization_id hr_organization_units.organization_id%TYPE;
3141: l_location_id per_all_assignments_f.location_id%TYPE;

Line 3266: lv_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

3262: -- End of Bug 6271548
3263:
3264: -- Modifications for the bug 8452959 Start
3265: lv_assignment_id per_all_assignments_f.assignment_id%TYPE;
3266: lv_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
3267: lv_count NUMBER;
3268: -- Modifications for the bug 8452959 End
3269:
3270:

Line 3293: pay_all_payrolls_f papf,

3289: CURSOR get_asg_active_range(p_asg_id NUMBER, p_tax_ref VARCHAR2) IS
3290: SELECT min(paaf.effective_start_date) min_active, max(paaf.effective_end_date) max_active
3291: FROM per_all_assignments_f paaf,
3292: per_assignment_status_types past,
3293: pay_all_payrolls_f papf,
3294: hr_soft_coding_keyflex flex
3295: WHERE paaf.assignment_id = p_asg_id
3296: AND paaf.assignment_status_type_id = past.assignment_status_type_id
3297: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 3362: ,pay_all_payrolls_f nroll

3358: cursor csr_asg_start(p_asg_id NUMBER, p_asg_end DATE,
3359: p_start_year DATE, p_end_year DATE) IS
3360: SELECT max(ass.effective_start_date)
3361: FROM per_all_assignments_f ass
3362: ,pay_all_payrolls_f nroll
3363: ,hr_soft_coding_keyflex flex
3364: ,per_all_assignments_f pass
3365: ,pay_all_payrolls_f proll
3366: ,hr_soft_coding_keyflex pflex

Line 3365: ,pay_all_payrolls_f proll

3361: FROM per_all_assignments_f ass
3362: ,pay_all_payrolls_f nroll
3363: ,hr_soft_coding_keyflex flex
3364: ,per_all_assignments_f pass
3365: ,pay_all_payrolls_f proll
3366: ,hr_soft_coding_keyflex pflex
3367: WHERE ass.assignment_id = p_asg_id
3368: AND ass.effective_start_date < p_asg_end
3369: AND nroll.payroll_id = ass.payroll_id

Line 3642: ,pay_all_payrolls_f nroll

3638: -- that had a different tax district at that date
3639: ( SELECT nvl(max(ass.effective_start_date),
3640: to_date('01-01-0001','DD-MM-YYYY'))
3641: FROM per_all_assignments_f ass
3642: ,pay_all_payrolls_f nroll
3643: ,hr_soft_coding_keyflex flex
3644: ,per_all_assignments_f pass -- previous assignment
3645: ,pay_all_payrolls_f proll
3646: ,hr_soft_coding_keyflex pflex

Line 3645: ,pay_all_payrolls_f proll

3641: FROM per_all_assignments_f ass
3642: ,pay_all_payrolls_f nroll
3643: ,hr_soft_coding_keyflex flex
3644: ,per_all_assignments_f pass -- previous assignment
3645: ,pay_all_payrolls_f proll
3646: ,hr_soft_coding_keyflex pflex
3647: WHERE ass.assignment_id = bal_assact.assignment_id
3648: AND nroll.payroll_id = ass.payroll_id
3649: AND ass.effective_start_date BETWEEN

Line 3917: pay_all_payrolls_f papf,

3913: lv_tax_ref varchar)
3914: is
3915: select count(*)
3916: from per_all_assignments_f paaf,
3917: pay_all_payrolls_f papf,
3918: hr_soft_coding_keyflex flex
3919: where paaf.assignment_id = lv_assignment_id
3920: and paaf.payroll_id = lv_payroll_id
3921: and paaf.effective_start_date < l_active_start