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

Line 15: FROM per_all_assignments_f

11: -- Cursor to get payroll_id of an assignment
12: -- =============================================================================
13: CURSOR csr_get_payroll_id(c_assignment_id IN NUMBER) IS
14: SELECT payroll_id
15: FROM per_all_assignments_f
16: WHERE assignment_id = c_assignment_id;
17: -- =============================================================================
18: -- Cursor to get all assig.actions for a given assig. within a date range
19: -- =============================================================================

Line 436: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

432: --=============================================================================
433: -- Function to get the age of a person given the effective date
434: --=============================================================================
435: FUNCTION get_age
436: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
437: ,p_effective_date IN DATE)
438: RETURN NUMBER IS
439:
440: CURSOR csr_get_dob IS

Line 443: ,per_all_assignments_f paf

439:
440: CURSOR csr_get_dob IS
441: SELECT trunc (date_of_birth)
442: FROM per_all_people_f per
443: ,per_all_assignments_f paf
444: WHERE per.person_id = paf.person_id
445: AND paf.assignment_id = p_assignment_id
446: AND p_effective_date BETWEEN per.effective_start_date
447: AND per.effective_end_date

Line 521: FROM per_all_assignments_f asg

517: -- ended assignment.
518: --
519: CURSOR csr_get_term_date IS
520: SELECT min (effective_start_date) - 1 term_date
521: FROM per_all_assignments_f asg
522: WHERE assignment_id = p_assignment_id
523: AND assignment_status_type_id IN
524: (
525: SELECT assignment_status_type_id

Line 536: FROM per_all_assignments_f asg

532: -- Get the dates for any ended assignments. Note that this is for sec
533: -- assignments only.
534: --
535: SELECT max (effective_end_date)
536: FROM per_all_assignments_f asg
537: WHERE assignment_id = p_assignment_id
538: AND asg.primary_flag = 'N'
539: AND NOT EXISTS
540: (

Line 542: FROM per_all_assignments_f asg1

538: AND asg.primary_flag = 'N'
539: AND NOT EXISTS
540: (
541: SELECT 1
542: FROM per_all_assignments_f asg1
543: WHERE asg1.assignment_id = p_assignment_id
544: AND asg1.effective_start_date = asg.effective_end_date + 1
545: AND asg.assignment_id = asg1.assignment_id
546: )

Line 550: FROM per_all_assignments_f asg1

546: )
547: AND NOT EXISTS
548: (
549: SELECT 1
550: FROM per_all_assignments_f asg1
551: WHERE asg1.assignment_id = p_assignment_id
552: AND asg1.effective_start_date > asg.effective_start_date
553: AND asg.assignment_id = asg1.assignment_id
554: AND asg1.assignment_status_type_id IN

Line 598: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

594:
595: END chk_asg_term_py;
596:
597: FUNCTION get_balance_value
598: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
599: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
600: ,p_payroll_id IN NUMBER
601: ,p_start_date IN DATE
602: ,p_end_date IN DATE

Line 599: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE

595: END chk_asg_term_py;
596:
597: FUNCTION get_balance_value
598: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
599: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
600: ,p_payroll_id IN NUMBER
601: ,p_start_date IN DATE
602: ,p_end_date IN DATE
603: ,p_balance_name IN pay_balance_types.balance_name%TYPE

Line 909: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

905: -- ==============================================================
906: -- Get_Pension_Salary -- Function to derive pension salary value
907: -- ==============================================================
908: FUNCTION get_pension_salary
909: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
910: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
911: ,p_payroll_id IN NUMBER
912: ,p_start_date IN DATE
913: ,p_end_date IN DATE

Line 910: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE

906: -- Get_Pension_Salary -- Function to derive pension salary value
907: -- ==============================================================
908: FUNCTION get_pension_salary
909: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
910: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
911: ,p_payroll_id IN NUMBER
912: ,p_start_date IN DATE
913: ,p_end_date IN DATE
914: ,p_asg_act IN NUMBER)

Line 989: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

985: -- ==============================================================
986: -- Function to derive current period part time percentage
987: -- ==============================================================
988: FUNCTION get_curr_ptp
989: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
990: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
991: ,p_payroll_id IN NUMBER
992: ,p_start_date IN DATE
993: ,p_end_date IN DATE

Line 990: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE

986: -- Function to derive current period part time percentage
987: -- ==============================================================
988: FUNCTION get_curr_ptp
989: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
990: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
991: ,p_payroll_id IN NUMBER
992: ,p_start_date IN DATE
993: ,p_end_date IN DATE
994: ,p_asg_act IN NUMBER) RETURN NUMBER IS

Line 999: FROM per_all_assignments_f paaf

995:
996: CURSOR csr_get_reg_working_hours(c_assignment_id IN NUMBER
997: ,c_end_date IN DATE) IS
998: SELECT normal_hours
999: FROM per_all_assignments_f paaf
1000: WHERE paaf.assignment_id = c_assignment_id
1001: AND c_end_date BETWEEN paaf.effective_start_date
1002: AND paaf.effective_end_date;
1003:

Line 1061: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

1057: -- ==============================================================
1058: -- Procedure to derive retro period part time percentage details
1059: -- ==============================================================
1060: PROCEDURE get_retro_ptp
1061: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1062: ,p_start_date IN DATE
1063: ,p_effective_date IN DATE
1064: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
1065: ,p_payroll_id IN NUMBER

Line 1064: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE

1060: PROCEDURE get_retro_ptp
1061: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1062: ,p_start_date IN DATE
1063: ,p_effective_date IN DATE
1064: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
1065: ,p_payroll_id IN NUMBER
1066: ,retro_ptp_data OUT NOCOPY tPTPData) IS
1067:
1068: -- Previously reported ptp to ABP

Line 1096: FROM per_all_assignments_f asg

1092: AND c_orig_ed_date;
1093: --=========================================================================
1094: CURSOR csr_get_hire_date(c_asg_id IN NUMBER) IS
1095: SELECT min (effective_start_date) hire_date
1096: FROM per_all_assignments_f asg
1097: WHERE assignment_id = c_asg_id
1098: AND assignment_status_type_id IN
1099: (
1100: SELECT assignment_status_type_id

Line 1109: FROM per_all_assignments_f asg

1105: AND assignment_type = 'E';
1106: --=========================================================================
1107: CURSOR csr_get_term_date(c_asg_id IN NUMBER) IS
1108: SELECT min (effective_start_date) - 1 term_date
1109: FROM per_all_assignments_f asg
1110: WHERE assignment_id = c_asg_id
1111: AND assignment_status_type_id IN
1112: (
1113: SELECT assignment_status_type_id

Line 1480: PROCEDURE pension_basis(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

1476: -- ===========================================================================
1477: -- Procedure to derive the Contribution Base for Pension Types
1478: -- OPNP,AAOP
1479: -- ===========================================================================
1480: PROCEDURE pension_basis(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1481: ,p_person_id IN NUMBER
1482: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
1483: ,p_payroll_id IN NUMBER
1484: ,p_start_date IN DATE

Line 1482: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE

1478: -- OPNP,AAOP
1479: -- ===========================================================================
1480: PROCEDURE pension_basis(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1481: ,p_person_id IN NUMBER
1482: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
1483: ,p_payroll_id IN NUMBER
1484: ,p_start_date IN DATE
1485: ,p_end_date IN DATE
1486: ,p_contr_basis_values IN OUT NOCOPY tPENSIONData)IS

Line 1875: PROCEDURE pension_contr(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

1871: -- ===================================================================================
1872: -- Procedure to derive the Contribution Amount for Pension Types
1873: -- OPNP_65,OPNP_W25,OPNP_W50,PPP,FPU_B
1874: -- ===================================================================================
1875: PROCEDURE pension_contr(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1876: ,p_person_id IN NUMBER
1877: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
1878: ,p_payroll_id IN NUMBER
1879: ,p_start_date IN DATE

Line 1877: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE

1873: -- OPNP_65,OPNP_W25,OPNP_W50,PPP,FPU_B
1874: -- ===================================================================================
1875: PROCEDURE pension_contr(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1876: ,p_person_id IN NUMBER
1877: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
1878: ,p_payroll_id IN NUMBER
1879: ,p_start_date IN DATE
1880: ,p_end_date IN DATE
1881: ,p_contr_amt_values IN OUT NOCOPY tPENSIONData)IS

Line 2376: ,per_all_assignments_f paa

2372: paa.assignment_id assignment_id
2373: ,paa.person_id
2374: FROM pay_payroll_actions ppa
2375: ,per_org_structure_versions posv
2376: ,per_all_assignments_f paa
2377: ,per_all_people_f pap
2378: WHERE posv.organization_structure_id = c_org_struct_id
2379: AND posv.date_from <= c_end_date
2380: AND nvl (posv.date_to

Line 2438: ,per_all_assignments_f asg

2434: ,c_bg_id IN NUMBER
2435: ,c_start_date IN DATE) IS
2436: SELECT 1
2437: FROM per_periods_of_service pps
2438: ,per_all_assignments_f asg
2439: WHERE asg.assignment_id = c_asg_id
2440: --AND c_effective_date BETWEEN asg.effective_start_date
2441: -- AND asg.effective_end_date
2442: AND asg.period_of_service_id = pps.period_of_service_id

Line 2449: FROM per_all_assignments_f asg

2445: AND pps.final_process_date < c_start_date
2446: UNION
2447: --secondary asgs
2448: SELECT 1
2449: FROM per_all_assignments_f asg
2450: WHERE assignment_id = c_asg_id
2451: AND business_group_id = c_bg_id
2452: AND effective_start_date < c_start_date
2453: AND asg.primary_flag = 'N'

Line 2744: FROM per_all_assignments_f pas

2740: CURSOR csr_get_asg_seq (c_assignment_id IN NUMBER
2741: ,c_effective_date IN DATE) IS
2742: SELECT to_char(lpad(pas.assignment_sequence,2,0)) asg_seq
2743: ,pas.assignment_number
2744: FROM per_all_assignments_f pas
2745: WHERE pas.assignment_id = c_assignment_id
2746: AND c_effective_date BETWEEN pas.effective_start_date
2747: AND pas.effective_end_date;
2748: --=========================================================================

Line 2756: FROM per_all_assignments_f pas

2752: ,decode (max (pas.effective_end_date)
2753: ,hr_general.end_of_time
2754: ,to_date (NULL)
2755: ,max (pas.effective_end_date)) asg_end_date
2756: FROM per_all_assignments_f pas
2757: WHERE pas.assignment_id = c_assignment_id;
2758: --=========================================================================
2759: -- Assignment Id
2760: CURSOR csr_asg_id (c_asg_action_id IN NUMBER

Line 2764: FROM per_all_assignments_f paaf

2760: CURSOR csr_asg_id (c_asg_action_id IN NUMBER
2761: ,c_payroll_action_id IN NUMBER) IS
2762: SELECT DISTINCT
2763: paa.assignment_id
2764: FROM per_all_assignments_f paaf
2765: ,pay_assignment_actions paa
2766: WHERE paa.payroll_action_id = c_payroll_action_id
2767: AND paa.assignment_action_id = c_asg_action_id
2768: AND paaf.assignment_id = paa.assignment_id;

Line 2773: FROM per_all_assignments_f

2769: --=========================================================================
2770: -- Person Id
2771: CURSOR csr_get_person_id(c_assignment_id IN NUMBER) IS
2772: SELECT person_id
2773: FROM per_all_assignments_f
2774: WHERE assignment_id = c_assignment_id;
2775: -- AND ROWNUM < 2;
2776: --=========================================================================
2777: -- Employee Number Override - New Data

Line 3015: ,per_all_assignments_f paaf

3011: CURSOR csr_income_code(c_assignment_id IN NUMBER
3012: ,c_effective_date IN DATE) IS
3013: SELECT hscf.segment8
3014: FROM hr_soft_coding_keyflex hscf
3015: ,per_all_assignments_f paaf
3016: WHERE paaf.assignment_id = c_assignment_id
3017: AND c_effective_date BETWEEN paaf.effective_start_date
3018: AND paaf.effective_end_date
3019: AND paaf.soft_coding_keyflex_id = hscf.soft_coding_keyflex_id;

Line 3027: FROM per_all_assignments_f asg

3023: ,c_end_date IN DATE
3024: ,c_assignment_id IN NUMBER) IS
3025: SELECT min (effective_start_date) - 1 term_date
3026: ,period_of_service_id
3027: FROM per_all_assignments_f asg
3028: WHERE assignment_id = c_assignment_id
3029: AND business_group_id = c_bg_id
3030: AND effective_start_date <= c_end_date
3031: AND assignment_status_type_id IN

Line 3044: FROM per_all_assignments_f asg

3040: -- Get the dates for any ended assignments. Note that this is for sec
3041: -- assignments only.
3042: SELECT max (effective_end_date)
3043: ,period_of_service_id
3044: FROM per_all_assignments_f asg
3045: WHERE assignment_id = c_assignment_id
3046: AND business_group_id = c_bg_id
3047: AND asg.primary_flag = 'N'
3048: AND effective_end_date <= c_end_date

Line 3052: FROM per_all_assignments_f asg1

3048: AND effective_end_date <= c_end_date
3049: AND NOT EXISTS
3050: (
3051: SELECT 1
3052: FROM per_all_assignments_f asg1
3053: WHERE asg1.assignment_id = c_assignment_id
3054: AND asg1.effective_start_date = asg.effective_end_date + 1
3055: AND asg.assignment_id = asg1.assignment_id
3056: )

Line 3060: FROM per_all_assignments_f asg1

3056: )
3057: AND NOT EXISTS
3058: (
3059: SELECT 1
3060: FROM per_all_assignments_f asg1
3061: WHERE asg1.assignment_id = c_assignment_id
3062: AND asg1.effective_start_date > asg.effective_start_date
3063: AND asg.assignment_id = asg1.assignment_id
3064: AND asg1.assignment_status_type_id IN

Line 3078: FROM per_all_assignments_f paaf

3074: --15859347
3075: CURSOR c_term_date(p_asg_id number, p_person_id number, p_bg_id number)
3076: IS
3077: SELECT max(paaf.effective_end_date)
3078: FROM per_all_assignments_f paaf
3079: WHERE
3080: paaf.assignment_id = p_asg_id
3081: AND paaf.person_id = p_person_id
3082: AND paaf.business_group_id = p_bg_id

Line 3100: ,per_all_assignments_f paaf

3096: ,'RESIGNATION' ,'W'
3097: ,'EARLY_RETIREMENT' ,'V'
3098: ,'R') term_reas
3099: FROM per_periods_of_service pps
3100: ,per_all_assignments_f paaf
3101: WHERE paaf.period_of_service_id = pps.period_of_service_id
3102: AND paaf.assignment_id = c_assignment_id
3103: AND c_effective_date BETWEEN paaf.effective_start_date
3104: AND paaf.effective_end_date;

Line 3335: l_asg_num per_all_assignments_f.assignment_number%TYPE;

3331: l_pay_period_count NUMBER:=1;
3332: l_prev_start_date DATE := hr_general.end_of_time;
3333: l_fetch VARCHAR2(1):='Y';
3334: l_temp NUMBER := 0;
3335: l_asg_num per_all_assignments_f.assignment_number%TYPE;
3336: l_kop_report VARCHAR2(1) := 'Y';
3337: l_kop_invalid VARCHAR2(1) := 'Y';
3338:
3339: l_wne_start_date DATE := NULL;

Line 3355: PROCEDURE pay_period_archive (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

3351: rec_wth_old_start csr_hire_dt_chg_wth%ROWTYPE;
3352: l_wth_prd_start_date DATE;
3353: l_wth_prd_end_date DATE;
3354: --=========================================================================
3355: PROCEDURE pay_period_archive (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3356: , p_person_id IN NUMBER
3357: , p_bg_id IN per_all_assignments_f.business_group_id%TYPE
3358: , p_payroll_id IN NUMBER
3359: , p_start_date IN DATE

Line 3357: , p_bg_id IN per_all_assignments_f.business_group_id%TYPE

3353: l_wth_prd_end_date DATE;
3354: --=========================================================================
3355: PROCEDURE pay_period_archive (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3356: , p_person_id IN NUMBER
3357: , p_bg_id IN per_all_assignments_f.business_group_id%TYPE
3358: , p_payroll_id IN NUMBER
3359: , p_start_date IN DATE
3360: , p_end_date IN DATE
3361: , p_term_flag IN VARCHAR)

Line 3364: l_assignment_id per_all_assignments_f.assignment_id%TYPE := p_assignment_id;

3360: , p_end_date IN DATE
3361: , p_term_flag IN VARCHAR)
3362: IS
3363:
3364: l_assignment_id per_all_assignments_f.assignment_id%TYPE := p_assignment_id;
3365: l_person_id NUMBER := p_person_id;
3366: l_bg_id per_all_assignments_f.business_group_id%TYPE := p_bg_id;
3367: l_payroll_id NUMBER := p_payroll_id;
3368: l_start_date DATE := p_start_date;

Line 3366: l_bg_id per_all_assignments_f.business_group_id%TYPE := p_bg_id;

3362: IS
3363:
3364: l_assignment_id per_all_assignments_f.assignment_id%TYPE := p_assignment_id;
3365: l_person_id NUMBER := p_person_id;
3366: l_bg_id per_all_assignments_f.business_group_id%TYPE := p_bg_id;
3367: l_payroll_id NUMBER := p_payroll_id;
3368: l_start_date DATE := p_start_date;
3369: l_end_date DATE := p_end_date;
3370: l_pension_st_date DATE;