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 735: pay_all_payrolls_f papf,

731: CURSOR get_first_active_start IS
732: SELECT max(paaf.effective_start_date) first_st_date, max(person_id) person_id
733: FROM per_all_assignments_f paaf,
734: per_assignment_status_types past,
735: pay_all_payrolls_f papf,
736: hr_soft_coding_keyflex flex
737: WHERE paaf.assignment_id = p_asg_id
738: AND paaf.assignment_status_type_id = past.assignment_status_type_id
739: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 753: pay_all_payrolls_f papf,

749: -- will not be able to return first Active/Susp Status date
750: CURSOR get_first_start IS
751: SELECT max(paaf.effective_start_date) first_st_date, max(person_id) person_id, max(period_of_service_id) pos_id
752: FROM per_all_assignments_f paaf,
753: pay_all_payrolls_f papf,
754: hr_soft_coding_keyflex flex
755: WHERE paaf.assignment_id = p_asg_id
756: AND paaf.payroll_id = papf.payroll_id
757: AND p_proll_eff_date BETWEEN papf.effective_start_date and papf.effective_end_date

Line 768: pay_all_payrolls_f papf,

764: CURSOR is_term_and_xfer IS
765: SELECT 'Y' term_and_xfer, flex.segment1 old_paye_ref
766: FROM per_all_assignments_f paaf,
767: per_assignment_status_types past,
768: pay_all_payrolls_f papf,
769: hr_soft_coding_keyflex flex
770: WHERE paaf.assignment_id = p_asg_id
771: AND paaf.assignment_status_type_id = past.assignment_status_type_id
772: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 787: pay_all_payrolls_f papf1,

783: CURSOR is_another_active_asg_xfer IS
784: SELECT 'Y'
785: FROM per_all_assignments_f paaf1,
786: per_assignment_status_types past1,
787: pay_all_payrolls_f papf1,
788: hr_soft_coding_keyflex flex1
789: WHERE paaf1.period_of_service_id = l_pos_id
790: AND paaf1.assignment_id <> p_asg_id
791: AND l_min_active BETWEEN paaf1.effective_start_date

Line 802: pay_all_payrolls_f papf2,

798: AND flex1.segment1 = p_tax_ref
799: AND EXISTS ( SELECT 1
800: FROM per_all_assignments_f paaf2,
801: per_assignment_status_types past2,
802: pay_all_payrolls_f papf2,
803: hr_soft_coding_keyflex flex2
804: WHERE paaf2.assignment_id = paaf1.assignment_id
805: AND l_min_active-1 BETWEEN paaf2.effective_start_date
806: AND paaf2.effective_end_date

Line 820: pay_all_payrolls_f papf,

816: CURSOR get_agg_min_start_date IS
817: SELECT min(paaf.effective_start_date) min_active
818: FROM per_all_assignments_f paaf,
819: per_assignment_status_types past,
820: pay_all_payrolls_f papf,
821: hr_soft_coding_keyflex flex
822: WHERE paaf.person_id = l_person_id
823: AND (l_min_active-1) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
824: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 936: pay_all_payrolls_f papf,

932: CURSOR get_last_active_end IS
933: SELECT max(paaf.effective_end_date) last_end_date, max(person_id) person_id
934: FROM per_all_assignments_f paaf,
935: per_assignment_status_types past,
936: pay_all_payrolls_f papf,
937: hr_soft_coding_keyflex flex
938: WHERE paaf.assignment_id = p_asg_id
939: AND paaf.assignment_status_type_id = past.assignment_status_type_id
940: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 954: pay_all_payrolls_f papf,

950: -- will not be able to return first Active/Susp Status date
951: CURSOR get_first_start IS
952: SELECT max(paaf.effective_start_date) first_st_date, max(person_id) person_id, max(period_of_service_id) pos_id
953: FROM per_all_assignments_f paaf,
954: pay_all_payrolls_f papf,
955: hr_soft_coding_keyflex flex
956: WHERE paaf.assignment_id = p_asg_id
957: AND paaf.payroll_id = papf.payroll_id
958: AND p_proll_eff_date BETWEEN papf.effective_start_date and papf.effective_end_date

Line 969: pay_all_payrolls_f papf,

965: CURSOR is_term_and_xfer IS
966: SELECT 'Y' term_and_xfer, flex.segment1 old_paye_ref
967: FROM per_all_assignments_f paaf,
968: per_assignment_status_types past,
969: pay_all_payrolls_f papf,
970: hr_soft_coding_keyflex flex
971: WHERE paaf.assignment_id = p_asg_id
972: AND paaf.assignment_status_type_id = past.assignment_status_type_id
973: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 988: pay_all_payrolls_f papf1,

984: CURSOR is_another_active_asg_xfer IS
985: SELECT 'Y'
986: FROM per_all_assignments_f paaf1,
987: per_assignment_status_types past1,
988: pay_all_payrolls_f papf1,
989: hr_soft_coding_keyflex flex1
990: WHERE paaf1.period_of_service_id = l_pos_id
991: AND paaf1.assignment_id <> p_asg_id
992: AND l_min_active BETWEEN paaf1.effective_start_date

Line 1003: pay_all_payrolls_f papf2,

999: AND flex1.segment1 = p_tax_ref
1000: AND EXISTS ( SELECT 1
1001: FROM per_all_assignments_f paaf2,
1002: per_assignment_status_types past2,
1003: pay_all_payrolls_f papf2,
1004: hr_soft_coding_keyflex flex2
1005: WHERE paaf2.assignment_id = paaf1.assignment_id
1006: AND l_min_active-1 BETWEEN paaf2.effective_start_date
1007: AND paaf2.effective_end_date

Line 1021: pay_all_payrolls_f papf,

1017: CURSOR get_agg_max_end_date IS
1018: SELECT max(paaf.effective_end_date) max_active
1019: FROM per_all_assignments_f paaf,
1020: per_assignment_status_types past,
1021: pay_all_payrolls_f papf,
1022: hr_soft_coding_keyflex flex
1023: WHERE paaf.person_id = l_person_id
1024: AND (l_max_active+1) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1025: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 1323: FROM pay_all_payrolls_f p,

1319: flex.segment16 * 100 sap_compensation,
1320: flex.segment17 * 100 spp_recovered,
1321: flex.segment18 * 100 spp_compensation
1322: End 4011263 */
1323: FROM pay_all_payrolls_f p,
1324: hr_soft_coding_keyflex flex,
1325: hr_organization_information org
1326: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1327: AND org.org_information_context = 'Tax Details References'

Line 1336: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

1332: AND org.organization_id = p_bg_id
1333: AND p_end_year BETWEEN p.effective_start_date
1334: AND p.effective_end_date;
1335: --
1336: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
1337: --
1338: -- cursor to find a different PAYE Ref within a tax year on a given payroll
1339: CURSOR csr_another_paye_ref(p_payroll_id NUMBER,
1340: p_end_year DATE,

Line 1343: FROM pay_all_payrolls_f p,

1339: CURSOR csr_another_paye_ref(p_payroll_id NUMBER,
1340: p_end_year DATE,
1341: p_paye_ref VARCHAR2) IS
1342: SELECT flex.segment1
1343: FROM pay_all_payrolls_f p,
1344: hr_soft_coding_keyflex flex
1345: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id(+)
1346: AND p.payroll_id = p_payroll_id
1347: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)

Line 1810: pay_all_payrolls_f ppf,

1806: decode(per.per_information9,'Y','Y',NULL) multiple_asg_flag,
1807: rowidtochar(asg.ROWID) charrowid,
1808: 'N' tax_ref_xfer
1809: FROM per_all_assignments_f asg,
1810: pay_all_payrolls_f ppf,
1811: hr_soft_coding_keyflex flex,
1812: hr_organization_information org,
1813: per_all_people_f per
1814: WHERE asg.person_id BETWEEN stperson AND endperson

Line 1891: ,pay_all_payrolls_f NROLL

1887: FROM
1888: per_all_people_f per
1889: ,per_all_assignments_f PASS
1890: ,per_all_assignments_f ASS
1891: ,pay_all_payrolls_f NROLL
1892: ,hr_soft_coding_keyflex FLEX
1893: ,pay_all_payrolls_f PROLL
1894: ,hr_soft_coding_keyflex pflex
1895: WHERE NROLL.payroll_id = ASS.payroll_id

Line 1893: ,pay_all_payrolls_f PROLL

1889: ,per_all_assignments_f PASS
1890: ,per_all_assignments_f ASS
1891: ,pay_all_payrolls_f NROLL
1892: ,hr_soft_coding_keyflex FLEX
1893: ,pay_all_payrolls_f PROLL
1894: ,hr_soft_coding_keyflex pflex
1895: WHERE NROLL.payroll_id = ASS.payroll_id
1896: AND ASS.effective_start_date between
1897: NROLL.effective_start_date and NROLL.effective_end_date

Line 2206: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

2202: l_payroll_period_type VARCHAR2(30);
2203: l_payroll_max_period_number NUMBER;
2204: l_payroll_tax_ref VARCHAR2(10);
2205: l_payroll_tax_dist VARCHAR2(10);
2206: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
2207: l_number_per_fiscal_yr NUMBER;
2208: --
2209: -- get the defined balance id for specified balance and dimension
2210: cursor get_defined_balance_id

Line 3022: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

3018: l_payroll_max_period_number NUMBER;
3019: l_payroll_tax_ref VARCHAR2(10);
3020: l_payroll_tax_dist VARCHAR2(3);
3021: --
3022: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
3023: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3024: l_person_id per_all_people_f.person_id%TYPE;
3025: l_organization_id hr_organization_units.organization_id%TYPE;
3026: l_location_id per_all_assignments_f.location_id%TYPE;

Line 3166: pay_all_payrolls_f papf,

3162: CURSOR get_asg_active_range(p_asg_id NUMBER, p_tax_ref VARCHAR2) IS
3163: SELECT min(paaf.effective_start_date) min_active, max(paaf.effective_end_date) max_active
3164: FROM per_all_assignments_f paaf,
3165: per_assignment_status_types past,
3166: pay_all_payrolls_f papf,
3167: hr_soft_coding_keyflex flex
3168: WHERE paaf.assignment_id = p_asg_id
3169: AND paaf.assignment_status_type_id = past.assignment_status_type_id
3170: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 3235: ,pay_all_payrolls_f nroll

3231: cursor csr_asg_start(p_asg_id NUMBER, p_asg_end DATE,
3232: p_start_year DATE, p_end_year DATE) IS
3233: SELECT max(ass.effective_start_date)
3234: FROM per_all_assignments_f ass
3235: ,pay_all_payrolls_f nroll
3236: ,hr_soft_coding_keyflex flex
3237: ,per_all_assignments_f pass
3238: ,pay_all_payrolls_f proll
3239: ,hr_soft_coding_keyflex pflex

Line 3238: ,pay_all_payrolls_f proll

3234: FROM per_all_assignments_f ass
3235: ,pay_all_payrolls_f nroll
3236: ,hr_soft_coding_keyflex flex
3237: ,per_all_assignments_f pass
3238: ,pay_all_payrolls_f proll
3239: ,hr_soft_coding_keyflex pflex
3240: WHERE ass.assignment_id = p_asg_id
3241: AND ass.effective_start_date < p_asg_end
3242: AND nroll.payroll_id = ass.payroll_id

Line 3507: ,pay_all_payrolls_f nroll

3503: /* that had a different tax district at that date */
3504: ( SELECT nvl(max(ass.effective_start_date),
3505: to_date('01-01-0001','DD-MM-YYYY'))
3506: FROM per_all_assignments_f ass
3507: ,pay_all_payrolls_f nroll
3508: ,hr_soft_coding_keyflex flex
3509: ,per_all_assignments_f pass /* previous assignment */
3510: ,pay_all_payrolls_f proll
3511: ,hr_soft_coding_keyflex pflex

Line 3510: ,pay_all_payrolls_f proll

3506: FROM per_all_assignments_f ass
3507: ,pay_all_payrolls_f nroll
3508: ,hr_soft_coding_keyflex flex
3509: ,per_all_assignments_f pass /* previous assignment */
3510: ,pay_all_payrolls_f proll
3511: ,hr_soft_coding_keyflex pflex
3512: WHERE ass.assignment_id = bal_assact.assignment_id
3513: AND nroll.payroll_id = ass.payroll_id
3514: AND ass.effective_start_date BETWEEN