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_ASSIGNMENTS_F

Line 69: select EFFECTIVE_START_DATE from per_all_assignments_f

65: L_EFFECTIVE_DATE date;
66: l_asg_start_date DATE;
67: --To Fetch the Assignment Start Date
68: Cursor c_asg_start_date is
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)

Line 123: FROM PER_ALL_ASSIGNMENTS_F PAAF,

119: CURSOR C_ASSIGNMENTS_AGG(V_PERSON_ID NUMBER)
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'

Line 133: FROM PER_ALL_ASSIGNMENTS_F

129: AND L_PRP_END_DATE BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE;
130: CURSOR C_PERSON_ID
131: IS
132: SELECT PERSON_ID
133: FROM PER_ALL_ASSIGNMENTS_F
134: WHERE ASSIGNMENT_ID =P_ASSIGNMENT_ID
135: AND L_PRP_END_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
136: --Remove as it is already defined in the Header
137: CURSOR C_DEF_BAL

Line 153: FROM PER_ALL_ASSIGNMENTS_F

149: CURSOR C_PAYROLL_ID
150: IS
151: SELECT PAYROLL_ID,
152: BUSINESS_GROUP_ID
153: FROM PER_ALL_ASSIGNMENTS_F
154: WHERE ASSIGNMENT_ID=P_ASSIGNMENT_ID
155: AND P_REGULAR_PAYMENT_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
156: -- To get PRP Dates Corresponding to the Payroll's Date Paid
157: CURSOR C_PRP_DETAILS

Line 199: FROM per_all_assignments_f paaf,

195: CURSOR C_AGGREGATION_CHECK(V_ASSIGNMENT_ID NUMBER)
196: IS
197: SELECT MAX(DECODE(pivf.name,'Aggregate Earnings',peevf.screen_entry_value)) Agg_earnings,
198: MAX(DECODE(pivf.name,'Main Entry for Aggregation',peevf.screen_entry_value)) Main_entry
199: FROM per_all_assignments_f paaf,
200: pay_element_types_f petf,
201: pay_input_values_f pivf,
202: pay_element_entries_f peef,
203: pay_element_entry_values_f peevf

Line 227: FROM per_all_assignments_f paaf,

223: MAX(DECODE(pivf.name,'Qualifying scheme exists',peevf.screen_entry_value)) QSE,
224: MAX(DECODE(pivf.name,'Opt Out Date',peevf.screen_entry_value)) OPT_OUT,
225: MAX(DECODE(pivf.name,'Postponement End Date',peevf.screen_entry_value)) POSTPONEMENT,
226: MAX(DECODE(pivf.name,'Eligible Job Holder Date',peevf.screen_entry_value)) EJH
227: FROM per_all_assignments_f paaf,
228: pay_element_types_f petf,
229: pay_input_values_f pivf,
230: pay_element_entries_f peef,
231: pay_element_entry_values_f peevf

Line 1288: FROM per_all_assignments_f paaf

1284: REGULAR_PAYMENT_DATE DATE_PAID
1285: FROM per_time_periods
1286: WHERE payroll_id IN
1287: (SELECT payroll_id
1288: FROM per_all_assignments_f paaf
1289: WHERE assignment_id = p_assignment_id
1290: AND G_PRP_END_DATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1291: )
1292: AND regular_payment_date BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE

Line 1307: FROM per_all_assignments_f paaf

1303: (SELECT time_period_id
1304: FROM per_time_periods
1305: WHERE payroll_id IN
1306: (SELECT payroll_id
1307: FROM per_all_assignments_f paaf
1308: WHERE assignment_id = p_assignment_id
1309: AND G_PRP_END_DATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1310: )
1311: AND regular_payment_date BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE

Line 1321: PER_ALL_ASSIGNMENTS_F PAAF,

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
1325: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID

Line 1553: select EFFECTIVE_START_DATE from per_all_assignments_f

1549: L_EFFECTIVE_DATE date;
1550: l_asg_start_date DATE;
1551: --To Fetch the Assignment Start Date
1552: Cursor c_asg_start_date is
1553: select EFFECTIVE_START_DATE from per_all_assignments_f
1554: where assignment_id = p_assignment_id
1555: and g_prp_end_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
1556: BEGIN
1557: P_REASON := ' ';

Line 1721: , per_all_assignments_f paaf

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
1725: AND g_prp_end_date >= paaf.effective_start_date

Line 1802: FROM per_all_assignments_f a,

1798: l_seg_collect seg_collection_table;
1799: CURSOR c_location(p_location VARCHAR2)
1800: IS
1801: SELECT 1
1802: FROM per_all_assignments_f a,
1803: hr_locations_all l
1804: WHERE assignment_id=p_assignment_id
1805: AND a.LOCATION_ID = l.LOCATION_ID
1806: AND l.location_code=p_location

Line 1811: FROM per_all_assignments_f a,

1807: AND G_PRP_END_DATE BETWEEN a.effective_start_date AND a.effective_end_date;
1808: CURSOR c_organization(p_org_name VARCHAR2)
1809: IS
1810: SELECT 1
1811: FROM per_all_assignments_f a,
1812: HR_ALL_ORGANIZATION_UNITS u
1813: WHERE assignment_id =p_assignment_id
1814: AND u.ORGANIZATION_ID = a.ORGANIZATION_ID
1815: AND u.business_group_id=g_business_group_id

Line 1821: FROM per_all_assignments_f a,

1817: AND G_PRP_END_DATE BETWEEN a.effective_start_date AND a.effective_end_date;
1818: CURSOR c_payroll(p_payroll_name VARCHAR2)
1819: IS
1820: SELECT 1
1821: FROM per_all_assignments_f a,
1822: pay_payrolls_f b
1823: WHERE assignment_id =p_assignment_id
1824: AND b.business_group_id = G_BUSINESS_GROUP_ID
1825: AND b.PAYROLL_ID = a.PAYROLL_ID

Line 1832: FROM per_all_assignments_f a,

1828: AND G_PRP_END_DATE BETWEEN b.effective_start_date AND b.effective_end_date;
1829: CURSOR c_grade(p_grade VARCHAR2)
1830: IS
1831: SELECT 1
1832: FROM per_all_assignments_f a,
1833: per_grades g
1834: WHERE assignment_id =p_assignment_id
1835: AND g.business_group_id = G_BUSINESS_GROUP_ID
1836: AND g.GRADE_ID = a.GRADE_ID

Line 1842: FROM per_all_assignments_f a,

1838: AND G_PRP_END_DATE BETWEEN a.effective_start_date AND a.effective_end_date;
1839: CURSOR c_job(p_job VARCHAR2)
1840: IS
1841: SELECT 1
1842: FROM per_all_assignments_f a,
1843: per_jobs j
1844: WHERE assignment_id =p_assignment_id
1845: AND j.business_group_id = G_BUSINESS_GROUP_ID
1846: AND j.JOB_ID = a.JOB_ID

Line 1852: FROM per_all_assignments_f a,

1848: AND G_PRP_END_DATE BETWEEN a.effective_start_date AND a.effective_end_date;
1849: CURSOR c_pay_basis(p_pay_basis VARCHAR2)
1850: IS
1851: SELECT 1
1852: FROM per_all_assignments_f a,
1853: per_pay_bases p
1854: WHERE assignment_id =p_assignment_id
1855: AND p.business_group_id = G_BUSINESS_GROUP_ID
1856: AND p.PAY_BASIS_ID = a.PAY_BASIS_ID

Line 1862: FROM per_all_assignments_f a,

1858: AND G_PRP_END_DATE BETWEEN a.effective_start_date AND a.effective_end_date;
1859: CURSOR c_position(p_position VARCHAR2)
1860: IS
1861: SELECT 1
1862: FROM per_all_assignments_f a,
1863: per_all_positions p
1864: WHERE assignment_id =p_assignment_id
1865: AND p.business_group_id = G_BUSINESS_GROUP_ID
1866: AND p.POSITION_ID = a.POSITION_ID

Line 1877: FROM per_all_assignments_f

1873: WHERE lookup_type = 'EMP_CAT'
1874: AND meaning = p_emp_category
1875: AND lookup_code IN
1876: (SELECT EMPLOYMENT_CATEGORY
1877: FROM per_all_assignments_f
1878: WHERE assignment_id=p_assignment_id
1879: AND G_PRP_END_DATE BETWEEN effective_start_date AND effective_end_date
1880: );
1881: BEGIN

Line 2418: FROM PER_ALL_ASSIGNMENTS_F PAAF

2414: l_final_flag NUMBER;
2415: CURSOR C_ASSIGNMENT_CHECK(p_people_group_id NUMBER)
2416: IS
2417: SELECT 1
2418: FROM PER_ALL_ASSIGNMENTS_F PAAF
2419: WHERE PAAF.ASSIGNMENT_ID = P_ASSIGNMENT_ID
2420: AND p_people_group_id = people_group_id
2421: AND G_PRP_END_DATE BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE;
2422: CURSOR c_group_name_check (p_group_name VARCHAR2)

Line 2868: select EFFECTIVE_START_DATE from per_all_assignments_f

2864: L_SERVICE_START DATE;
2865: l_asg_start_date DATE;
2866: --To Fetch the Assignment Start Date
2867: Cursor c_asg_start_date is
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)

Line 2901: PER_ALL_ASSIGNMENTS_F PAAF,

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
2905: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID

Line 3051: PER_ALL_ASSIGNMENTS_F PAAF,

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
3055: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID

Line 3159: l_assgn_number per_all_assignments_f.assignment_number%type;

3155: SELECT DISTINCT line_text
3156: FROM pay_message_lines
3157: WHERE source_id = p_assignment_action_id
3158: AND payroll_id = 111;
3159: l_assgn_number per_all_assignments_f.assignment_number%type;
3160: BEGIN
3161: fnd_file.put_line(fnd_file.OUTPUT,'ASSIGNMENTS PROCESSED SUCCESSFULLY');
3162: fnd_file.put_line(fnd_file.OUTPUT,'----------------------------------');
3163: --fnd_file.put_line(fnd_file.OUTPUT,'-----------------------------------');

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 3336: sqlstr := 'select distinct paaf.person_id '|| 'from pay_payroll_actions ppa, '|| 'per_all_assignments_f paaf '|| 'where ppa.payroll_action_id = :payroll_action_id '||

3332: */ -- bug 14813352
3333: IF G_PAYROLL_ID IS NOT NULL THEN
3334: -- Payroll ID used in param, restrict by this.
3335: hr_utility.set_location(l_proc,20);
3336: sqlstr := 'select distinct paaf.person_id '|| 'from pay_payroll_actions ppa, '|| 'per_all_assignments_f paaf '|| 'where ppa.payroll_action_id = :payroll_action_id '||
3337: 'and paaf.business_group_id + 0 = ppa.business_group_id '|| 'and paaf.payroll_id = '||G_PAYROLL_ID|| ' order by paaf.person_id';
3338: ELSE
3339: sqlstr := 'select distinct person_id '|| 'from per_people_f ppf, '|| 'pay_payroll_actions ppa '|| 'where ppa.payroll_action_id = :payroll_action_id '|| 'and ppa.business_group_id = ppf.business_group_id '||
3340: 'order by ppf.person_id';

Line 3379: FROM PER_ALL_ASSIGNMENTS_F PAAF ,

3375: -- Cursor to fetch all Active assignments for the Payroll
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

Line 3573: FROM per_all_assignments_f paaf

3569: REGULAR_PAYMENT_DATE DATE_PAID
3570: FROM per_time_periods
3571: WHERE payroll_id IN
3572: (SELECT payroll_id
3573: FROM per_all_assignments_f paaf
3574: WHERE assignment_id = p_assignment_id
3575: AND L_PRP_END_DATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date
3576: )
3577: AND regular_payment_date BETWEEN L_PRP_START_DATE AND L_PRP_END_DATE

Line 3592: FROM per_all_assignments_f paaf

3588: (SELECT time_period_id
3589: FROM per_time_periods
3590: WHERE payroll_id IN
3591: (SELECT payroll_id
3592: FROM per_all_assignments_f paaf
3593: WHERE assignment_id = p_assignment_id
3594: AND L_PRP_END_DATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date
3595: )
3596: AND regular_payment_date BETWEEN L_PRP_START_DATE AND L_PRP_END_DATE

Line 3606: PER_ALL_ASSIGNMENTS_F PAAF,

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
3610: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID

Line 3823: select EFFECTIVE_START_DATE from per_all_assignments_f

3819: L_EFFECTIVE_DATE date;
3820: l_asg_start_date DATE;
3821: --To Fetch the Assignment Start Date
3822: Cursor c_asg_start_date is
3823: select EFFECTIVE_START_DATE from per_all_assignments_f
3824: where assignment_id = p_assignment_id
3825: and g_prp_end_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
3826: BEGIN
3827: P_REASON := ' ';

Line 4004: FROM PER_ALL_ASSIGNMENTS_F PAAF ,

4000: SELECT PAAF.PERSON_ID ,PAAF.EFFECTIVE_START_DATE,
4001: PAAF.ASSIGNMENT_ID ,
4002: PEEF.ELEMENT_ENTRY_ID ,
4003: PAAF.ASSIGNMENT_NUMBER
4004: FROM PER_ALL_ASSIGNMENTS_F PAAF ,
4005: PAY_ELEMENT_ENTRIES_F PEEF,
4006: PAY_ASSIGNMENT_ACTIONS PAA
4007: WHERE PAAF.PAYROLL_ID = G_PAYROLL_ID
4008: AND PAAF.ASSIGNMENT_ID = PEEF.ASSIGNMENT_ID

Line 4059: PER_ALL_ASSIGNMENTS_F PAAF,

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
4063: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID

Line 4225: L_ASSIGN_NUM_CHECK PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE :=NULL;

4221: L_OPTOUT_END_DATE DATE :=NULL;
4222: L_ELIGIBLE_JH_DATE DATE :=NULL;
4223: -- Other Local Variables
4224: L_MAX_POSTPO_DATE DATE;
4225: L_ASSIGN_NUM_CHECK PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE :=NULL;
4226: L_EMPLOYER_COMPONENT PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
4227: L_DEFAULT_SCHEME_NAME PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
4228: L_DEFAULT_SCH_ELEMENT_NAME PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME%TYPE :=NULL;
4229: L_AGE_START NUMBER :=0;

Line 4240: L_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE :=NULL;

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;
4244: L_PENSION_ENTRY_ID NUMBER;