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_ALL_PEOPLE_F

Line 46: L_SEX PER_ALL_PEOPLE_F.SEX%TYPE;

42: L_TOTAL_QUAL_EARNINGS NUMBER;
43: L_PERIOD_TYPE PAY_PAYROLLS_F.PERIOD_TYPE%TYPE;
44: L_PERSON_ID NUMBER;
45: L_AGE NUMBER;
46: L_SEX PER_ALL_PEOPLE_F.SEX%TYPE;
47: L_DATE_OF_BIRTH DATE;
48: L_BUSINESS_GROUP_ID NUMBER;
49: L_EMPLOYEE_STATUS NUMBER;
50: L_AUTO_ENROL_DATE VARCHAR2(30);

Line 73: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)

69: select EFFECTIVE_START_DATE from per_all_assignments_f
70: where assignment_id = p_assignment_id
71: and l_prp_end_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
72: ---To Fetch Service Start Date of the employee
73: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
74: IS
75: SELECT DATE_START
76: FROM PER_PERIODS_OF_SERVICE
77: WHERE PERSON_ID = P_PERSON_ID

Line 115: FROM PER_ALL_PEOPLE_F

111: IS
112: SELECT MONTHS_BETWEEN(P_REGULAR_PAYMENT_DATE,DATE_OF_BIRTH)/12,
113: SEX,
114: DATE_OF_BIRTH
115: FROM PER_ALL_PEOPLE_F
116: WHERE PERSON_ID = V_PERSON_ID
117: AND P_REGULAR_PAYMENT_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
118: --Cursor for aggregated case
119: CURSOR C_ASSIGNMENTS_AGG(V_PERSON_ID NUMBER)

Line 1320: FROM PER_ALL_PEOPLE_F PAPF,

1316: IS
1317: SELECT PAAF.PAYROLL_ID,
1318: PAAF.ASSIGNMENT_ID,
1319: PEEF.ELEMENT_ENTRY_ID
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

Line 1499: L_SEX PER_ALL_PEOPLE_F.SEX%type;

1495: P_AGE OUT NOCOPY NUMBER,
1496: P_REASON OUT NOCOPY VARCHAR2)
1497: RETURN NUMBER
1498: IS
1499: L_SEX PER_ALL_PEOPLE_F.SEX%type;
1500: L_AGE NUMBER;
1501: L_EMPLOYEE_STATUS_FOR_PENSION NUMBER;
1502: L_DATE_OF_BIRTH PER_ALL_PEOPLE_F.DATE_OF_BIRTH%type;
1503: L_NUM_DATE_BIRTH VARCHAR2(10);

Line 1502: L_DATE_OF_BIRTH PER_ALL_PEOPLE_F.DATE_OF_BIRTH%type;

1498: IS
1499: L_SEX PER_ALL_PEOPLE_F.SEX%type;
1500: L_AGE NUMBER;
1501: L_EMPLOYEE_STATUS_FOR_PENSION NUMBER;
1502: L_DATE_OF_BIRTH PER_ALL_PEOPLE_F.DATE_OF_BIRTH%type;
1503: L_NUM_DATE_BIRTH VARCHAR2(10);
1504: CURSOR C_AGE_SEX
1505: IS
1506: SELECT months_between (least (effective_end_date, g_prp_end_date), date_of_birth) / 12

Line 1509: FROM per_all_people_f papf

1505: IS
1506: SELECT months_between (least (effective_end_date, g_prp_end_date), date_of_birth) / 12
1507: , date_of_birth
1508: , sex
1509: FROM per_all_people_f papf
1510: WHERE person_id = p_person_id
1511: AND effective_start_date =
1512: (
1513: SELECT max (effective_start_date)

Line 1514: FROM per_all_people_f

1510: WHERE person_id = p_person_id
1511: AND effective_start_date =
1512: (
1513: SELECT max (effective_start_date)
1514: FROM per_all_people_f
1515: WHERE person_id = papf.person_id
1516: AND effective_start_date <= g_prp_end_date
1517: AND current_employee_flag = 'Y'
1518: )

Line 1524: FROM PER_ALL_PEOPLE_F

1520: /*
1521: SELECT MONTHS_BETWEEN(G_PRP_END_DATE,DATE_OF_BIRTH)/12,
1522: DATE_OF_BIRTH,
1523: SEX
1524: FROM PER_ALL_PEOPLE_F
1525: WHERE PERSON_ID = P_PERSON_ID
1526: AND G_PRP_END_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
1527: */
1528:

Line 1535: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)

1531: from per_time_period_types
1532: where PERIOD_TYPE = G_PAYROLL_PERIOD_TYPE;
1533:
1534: ---To Fetch Service Start Date of the employee
1535: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
1536: IS
1537: SELECT DATE_START
1538: FROM PER_PERIODS_OF_SERVICE
1539: WHERE PERSON_ID = P_PERSON_ID

Line 2872: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)

2868: select EFFECTIVE_START_DATE from per_all_assignments_f
2869: where assignment_id = p_assignment_id
2870: and g_prp_end_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2871: ---To Fetch Service Start Date of the employee
2872: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
2873: IS
2874: SELECT DATE_START
2875: FROM PER_PERIODS_OF_SERVICE
2876: WHERE PERSON_ID = P_PERSON_ID

Line 2900: FROM PER_ALL_PEOPLE_F PAPF,

2896: SELECT PAAF.PAYROLL_ID,PAAF.EFFECTIVE_START_DATE,
2897: PAAF.ASSIGNMENT_ID,
2898: PEEF.ELEMENT_ENTRY_ID,
2899: PAAF.ASSIGNMENT_NUMBER
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

Line 3028: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,

3024: (Aggregated) Active assignments under that employee will be processed in this procedure except the Main Entry.
3025: Main Entry Will be processed in the Enroll Pensions even before this Procedure is called.
3026: */
3027: PROCEDURE AGGREGATED(
3028: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
3029: L_QUALIFYING_SCHEME_NAME PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE ,
3030: L_AGGREGATION_FLAG VARCHAR2,
3031: L_AUTO_ENROLLMENT_DATE DATE,
3032: L_QUALIFYING_SCHEME_EXISTS VARCHAR2 ,

Line 3050: FROM PER_ALL_PEOPLE_F PAPF,

3046: SELECT PAAF.PAYROLL_ID,
3047: PAAF.ASSIGNMENT_ID,
3048: PEEF.ELEMENT_ENTRY_ID,
3049: PAAF.ASSIGNMENT_NUMBER
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

Line 3605: FROM PER_ALL_PEOPLE_F PAPF,

3601: IS
3602: SELECT PAAF.PAYROLL_ID,
3603: PAAF.ASSIGNMENT_ID,
3604: PEEF.ELEMENT_ENTRY_ID
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

Line 3791: L_SEX PER_ALL_PEOPLE_F.SEX%type;

3787: P_AGE OUT NOCOPY NUMBER,
3788: P_REASON OUT NOCOPY VARCHAR2)
3789: RETURN NUMBER
3790: IS
3791: L_SEX PER_ALL_PEOPLE_F.SEX%type;
3792: L_AGE NUMBER;
3793: L_EMPLOYEE_STATUS_FOR_PENSION NUMBER;
3794: L_DATE_OF_BIRTH PER_ALL_PEOPLE_F.DATE_OF_BIRTH%type;
3795: L_NUM_DATE_BIRTH VARCHAR2(10);

Line 3794: L_DATE_OF_BIRTH PER_ALL_PEOPLE_F.DATE_OF_BIRTH%type;

3790: IS
3791: L_SEX PER_ALL_PEOPLE_F.SEX%type;
3792: L_AGE NUMBER;
3793: L_EMPLOYEE_STATUS_FOR_PENSION NUMBER;
3794: L_DATE_OF_BIRTH PER_ALL_PEOPLE_F.DATE_OF_BIRTH%type;
3795: L_NUM_DATE_BIRTH VARCHAR2(10);
3796: CURSOR C_AGE_SEX
3797: IS
3798: SELECT MONTHS_BETWEEN(FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),DATE_OF_BIRTH)/12,

Line 3801: FROM PER_ALL_PEOPLE_F

3797: IS
3798: SELECT MONTHS_BETWEEN(FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE),DATE_OF_BIRTH)/12,
3799: DATE_OF_BIRTH,
3800: SEX
3801: FROM PER_ALL_PEOPLE_F
3802: WHERE PERSON_ID = P_PERSON_ID;
3803:
3804: ---To Fetch Service Start Date of the employee
3805: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)

Line 3805: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)

3801: FROM PER_ALL_PEOPLE_F
3802: WHERE PERSON_ID = P_PERSON_ID;
3803:
3804: ---To Fetch Service Start Date of the employee
3805: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
3806: IS
3807: SELECT DATE_START
3808: FROM PER_PERIODS_OF_SERVICE
3809: WHERE PERSON_ID = P_PERSON_ID

Line 3942: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)

3938: l_proc CONSTANT VARCHAR2(35):= 'archive_code';
3939: ------------------------------------------------------------------------------------------
3940: ------------------------------------------------------------------------------------------
3941: ---To Fetch Service Start Date of the employee
3942: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
3943: IS
3944: SELECT DATE_START
3945: FROM PER_PERIODS_OF_SERVICE
3946: WHERE PERSON_ID = P_PERSON_ID

Line 3950: CURSOR C_AGE_BETWEEN_PAYROLL (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)

3946: WHERE PERSON_ID = P_PERSON_ID
3947: AND BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID;
3948: ------------------------------------------------------------------------------------------
3949: ---To find If the Person reaches 22 Yrs. within the Payroll Period
3950: CURSOR C_AGE_BETWEEN_PAYROLL (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
3951: IS
3952: SELECT DATE_OF_BIRTH
3953: FROM PER_ALL_PEOPLE_F
3954: WHERE PERSON_ID = P_PERSON_ID

Line 3953: FROM PER_ALL_PEOPLE_F

3949: ---To find If the Person reaches 22 Yrs. within the Payroll Period
3950: CURSOR C_AGE_BETWEEN_PAYROLL (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
3951: IS
3952: SELECT DATE_OF_BIRTH
3953: FROM PER_ALL_PEOPLE_F
3954: WHERE PERSON_ID = P_PERSON_ID
3955: AND G_PRP_END_DATE >= EFFECTIVE_START_DATE
3956: AND G_PRP_START_DATE <= EFFECTIVE_END_DATE;
3957: -- AND G_PRP_END_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

Line 4021: FROM PER_ALL_PEOPLE_F

4017: -- Cursor to Fetch Person's Name
4018: CURSOR PERSON_NAME(P_PERSON_ID NUMBER)
4019: IS
4020: SELECT FULL_NAME
4021: FROM PER_ALL_PEOPLE_F
4022: WHERE PERSON_ID =P_PERSON_ID
4023: AND BUSINESS_GROUP_ID=G_BUSINESS_GROUP_ID
4024: AND G_PRP_END_DATE >= EFFECTIVE_START_DATE
4025: AND G_PRP_START_DATE <= EFFECTIVE_END_DATE;

Line 4058: FROM PER_ALL_PEOPLE_F PAPF,

4054: ------------------------------------------------------------------------------------------
4055: CURSOR C_MAIN_ENTRY_CHECK(P_PERSON_ID NUMBER,P_ASSIGNMENT_ID NUMBER)
4056: IS
4057: SELECT PAAF.ASSIGNMENT_NUMBER
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

Line 4178: CURSOR C_EMP_PENSION_STAGING_DATE(P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)

4174: AND scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id
4175: AND G_PRP_END_DATE BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
4176:
4177: -- to get pensions staging date at Employee/Person level
4178: CURSOR C_EMP_PENSION_STAGING_DATE(P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
4179: IS
4180: SELECT pei_information1
4181: FROM per_people_extra_info
4182: WHERE pei_information_category LIKE 'GB_PENSIONS_STAGING_DATE'

Line 4239: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE :=NULL;

4235: L_WORKER_POSTP_FLAG VARCHAR2(3) DEFAULT 'N';
4236: L_EJH_POSTP_FLAG VARCHAR2(3) DEFAULT 'N';
4237: L_SERVICE_START DATE :=NULL;
4238: L_TEMP VARCHAR2(30);
4239: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE :=NULL;
4240: L_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE :=NULL;
4241: L_ELEMENT_ENTRY_ID PAY_ELEMENT_ENTRIES_F.ELEMENT_ENTRY_ID%TYPE :=NULL;
4242: -- L_PENSION_ENTRY_START DATE; -- Bug 14343133
4243: L_PENSION_ENTRY_END DATE;

Line 4245: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE;

4241: L_ELEMENT_ENTRY_ID PAY_ELEMENT_ENTRIES_F.ELEMENT_ENTRY_ID%TYPE :=NULL;
4242: -- L_PENSION_ENTRY_START DATE; -- Bug 14343133
4243: L_PENSION_ENTRY_END DATE;
4244: L_PENSION_ENTRY_ID NUMBER;
4245: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
4246: L_ASSIGNMENT_NUMBER VARCHAR2(30);
4247: L_NOMINAL_AUTO_ENROLL_DATE DATE;
4248: L_NOMINAL_FLAG VARCHAR(3) :='N';
4249: -- L_PREV_PER_START_DATE DATE;