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_ENROLL_PENSION dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 124: PER_ASSIGNMENT_STATUS_TYPES PAST

120: IS
121: SELECT PAAF.ASSIGNMENT_ID,
122: PAAF.PAYROLL_ID
123: FROM PER_ALL_ASSIGNMENTS_F PAAF,
124: PER_ASSIGNMENT_STATUS_TYPES PAST
125: WHERE PAAF.PERSON_ID = V_PERSON_ID
126: AND PAAF.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
127: -- AND PAST.PAY_SYSTEM_STATUS='P'
128: AND PAST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'

Line 1324: PER_ASSIGNMENT_STATUS_TYPES PAST

1320: FROM PER_ALL_PEOPLE_F PAPF,
1321: PER_ALL_ASSIGNMENTS_F PAAF,
1322: PAY_ELEMENT_ENTRY_VALUES_F PEEVF,
1323: PAY_ELEMENT_ENTRIES_F PEEF,
1324: PER_ASSIGNMENT_STATUS_TYPES PAST
1325: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID
1326: AND PAPF.PERSON_ID =P_PERSON_ID
1327: AND PAAF.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
1328: -- AND PAST.PAY_SYSTEM_STATUS='P'

Line 1720: FROM per_assignment_status_types past

1716: , assignment_action_id DESC;
1717:
1718: cursor c_get_pay_status(p_person_id number,p_assignment_id number) is
1719: SELECT past.pay_system_status
1720: FROM per_assignment_status_types past
1721: , per_all_assignments_f paaf
1722: WHERE past.assignment_status_type_id = paaf.assignment_status_type_id
1723: AND paaf.assignment_id = p_assignment_id
1724: AND paaf.person_id = p_person_id

Line 1733: L_PAY_STATUS per_assignment_status_types.pay_system_status%TYPE;-- bug 16169601

1729: L_EMPLOYEE_STATUS_FOR_PENSION NUMBER;
1730: L_AGE NUMBER;
1731: L_REASON VARCHAR2(200);
1732: payroll_run c_payroll_run%ROWTYPE; -- bug 16169601
1733: L_PAY_STATUS per_assignment_status_types.pay_system_status%TYPE;-- bug 16169601
1734:
1735: BEGIN
1736: HR_UTILITY.trace(' Entered ASSESS_EMPLOYEE_PROCESS');
1737: --L_PENSIONABLE_EARNINGS := CALCULATE_EARNINGS(P_ASSIGNMENT_ID,P_AGGR_FLAG,P_PERSON_ID,G_EARN_END_DATE,p_assactid); -- Bug 14015189

Line 2904: PER_ASSIGNMENT_STATUS_TYPES PAST

2900: FROM PER_ALL_PEOPLE_F PAPF,
2901: PER_ALL_ASSIGNMENTS_F PAAF,
2902: PAY_ELEMENT_ENTRY_VALUES_F PEEVF,
2903: PAY_ELEMENT_ENTRIES_F PEEF,
2904: PER_ASSIGNMENT_STATUS_TYPES PAST
2905: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID
2906: AND PAPF.PERSON_ID =L_PERSON_ID
2907: AND PAAF.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
2908: -- AND PAST.PAY_SYSTEM_STATUS='P'

Line 3054: PER_ASSIGNMENT_STATUS_TYPES PAST

3050: FROM PER_ALL_PEOPLE_F PAPF,
3051: PER_ALL_ASSIGNMENTS_F PAAF,
3052: PAY_ELEMENT_ENTRY_VALUES_F PEEVF,
3053: PAY_ELEMENT_ENTRIES_F PEEF,
3054: PER_ASSIGNMENT_STATUS_TYPES PAST
3055: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID
3056: AND PAPF.PERSON_ID =L_PERSON_ID
3057: AND PAAF.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
3058: -- AND PAST.PAY_SYSTEM_STATUS='P'

Line 3327: sqlstr := 'select distinct ppf.person_id ' || 'from per_people_f ppf, ' || 'pay_payroll_actions ppa, ' || 'per_all_assignments_f paaf, ' || 'per_assignment_status_types past ' ||

3323: RAISE_APPLICATION_ERROR (-20001,'Please check the Staging Date / Default Pension Scheme if they are properly set up.') ;
3324: END IF;-- Staging Date
3325: bug 16178067 */
3326: /* IF G_BUSINESS_GROUP_ID IS NOT NULL AND G_PAYROLL_ID IS NOT NULL AND G_PRP_END_DATE IS NOT NULL THEN
3327: sqlstr := 'select distinct ppf.person_id ' || 'from per_people_f ppf, ' || 'pay_payroll_actions ppa, ' || 'per_all_assignments_f paaf, ' || 'per_assignment_status_types past ' ||
3328: 'where ppa.payroll_action_id = :PAYROLL_ACTION_ID ' || ' and ppa.business_group_id = ' ||G_BUSINESS_GROUP_ID || ' and paaf.payroll_id = ' ||G_PAYROLL_ID || ' and paaf.person_id = ppf.person_id ' ||
3329: ' and paaf.assignment_status_type_id = past.assignment_status_type_id ' || 'and past.PER_SYSTEM_status=''ACTIVE_ASSIGN'' ' || 'and ' ||''''||
3330: G_PRP_END_DATE ||''''||' between paaf.effective_start_date and paaf.effective_end_date ' || 'order by ppf.person_id' ;
3331: ELSIF G_PAYROLL_ID IS NOT NULL THEN

Line 3380: PER_ASSIGNMENT_STATUS_TYPES PAST

3376: CURSOR C_ALL_ASSIGNMENTS_PAYROLL
3377: IS
3378: SELECT DISTINCT PAAF.ASSIGNMENT_ID
3379: FROM PER_ALL_ASSIGNMENTS_F PAAF ,
3380: PER_ASSIGNMENT_STATUS_TYPES PAST
3381: WHERE PAAF.PAYROLL_ID = G_PAYROLL_ID
3382: AND PAAF.BUSINESS_GROUP_ID=G_BUSINESS_GROUP_ID
3383: AND PAAF.PERSON_ID BETWEEN stperson AND endperson
3384: AND PAAF.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID

Line 3609: PER_ASSIGNMENT_STATUS_TYPES PAST

3605: FROM PER_ALL_PEOPLE_F PAPF,
3606: PER_ALL_ASSIGNMENTS_F PAAF,
3607: PAY_ELEMENT_ENTRY_VALUES_F PEEVF,
3608: PAY_ELEMENT_ENTRIES_F PEEF,
3609: PER_ASSIGNMENT_STATUS_TYPES PAST
3610: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID
3611: AND PAPF.PERSON_ID =P_PERSON_ID
3612: AND PAAF.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
3613: -- AND PAST.PAY_SYSTEM_STATUS='P'

Line 4062: PER_ASSIGNMENT_STATUS_TYPES PAST

4058: FROM PER_ALL_PEOPLE_F PAPF,
4059: PER_ALL_ASSIGNMENTS_F PAAF,
4060: PAY_ELEMENT_ENTRY_VALUES_F PEEVF,
4061: PAY_ELEMENT_ENTRIES_F PEEF,
4062: PER_ASSIGNMENT_STATUS_TYPES PAST
4063: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID
4064: AND PAPF.PERSON_ID =P_PERSON_ID
4065: AND PAAF.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
4066: -- AND PAST.PAY_SYSTEM_STATUS='P'