APPS.PSP_ORG_DLS_PKG dependencies on PER_ASSIGNMENTS_F

Line 149: from PER_ASSIGNMENTS_F a

145:
146: dbms_sql.parse(l_cur_handle1, 'Select DISTINCT a.Assignment_ID ASSIGNMENT_ID,
147: a.Organization_ID ORGANIZATION_ID,
148: a.Person_ID PERSON_ID
149: from PER_ASSIGNMENTS_F a
150: where ' || g_organization_str || '
151: and a.business_group_id = '|| p_business_group_id ||'
152: and a.payroll_id in ( select payroll_id from
153: pay_payrolls_f where gl_set_of_books_id = '|| p_set_of_books_id || ')

Line 282: from PER_ASSIGNMENTS_F a,

278: d.SCHEDULE_BEGIN_DATE SCHEDULE_BEGIN_DATE,
279: d.SCHEDULE_END_DATE SCHEDULE_END_DATE,
280: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,
281: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE
282: from PER_ASSIGNMENTS_F a,
283: PSP_SCHEDULES b,
284: PSP_SCHEDULE_HIERARCHY c,
285: PSP_SCHEDULE_LINES d,
286: PSP_DEFAULT_LABOR_SCHEDULES f

Line 465: from PER_ASSIGNMENTS_F a,

461: d.SCHEDULE_BEGIN_DATE SCHEDULE_BEGIN_DATE,
462: d.SCHEDULE_END_DATE SCHEDULE_END_DATE,
463: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,
464: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE
465: from PER_ASSIGNMENTS_F a,
466: PSP_SCHEDULES b,
467: PSP_SCHEDULE_HIERARCHY c,
468: PSP_SCHEDULE_LINES d,
469: PSP_GROUP_ELEMENT_LIST f,

Line 734: from PER_ASSIGNMENTS_F a,

730: d.SCHEDULE_BEGIN_DATE SCHEDULE_BEGIN_DATE,
731: d.SCHEDULE_END_DATE SCHEDULE_END_DATE,
732: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,
733: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE
734: from PER_ASSIGNMENTS_F a,
735: PSP_SCHEDULES b,
736: PSP_SCHEDULE_HIERARCHY c,
737: PSP_SCHEDULE_LINES d,
738: PSP_DEFAULT_LABOR_SCHEDULES f

Line 1176: from PER_ASSIGNMENTS_F a,

1172: Cursor C1 is
1173: select DISTINCT c.ASSIGNMENT_ID,
1174: d.SCHEDULE_BEGIN_DATE,
1175: d.SCHEDULE_END_DATE
1176: from PER_ASSIGNMENTS_F a,
1177: PSP_SCHEDULES b,
1178: PSP_SCHEDULE_HIERARCHY c,
1179: PSP_SCHEDULE_LINES d,
1180: PSP_GROUP_ELEMENT_LIST e

Line 1196: from PER_ASSIGNMENTS_F a,

1192: Cursor C1 is
1193: select DISTINCT c.ASSIGNMENT_ID,
1194: d.SCHEDULE_BEGIN_DATE,
1195: d.SCHEDULE_END_DATE
1196: from PER_ASSIGNMENTS_F a,
1197: PSP_SCHEDULES b,
1198: PSP_SCHEDULE_HIERARCHY c,
1199: PSP_SCHEDULE_LINES d
1200: where a.assignment_id = b.assignment_id

Line 1251: from PER_ASSIGNMENTS_F a,

1247: l_GE_Period1_Start IN OUT NOCOPY DATE, l_GE_Period1_End IN OUT NOCOPY DATE,
1248: l_GE_Period2_Start IN OUT NOCOPY DATE, l_GE_Period2_End IN OUT NOCOPY DATE) return NUMBER IS
1249: Cursor C1 is
1250: Select DISTINCT e.Start_Date_Active, e.End_Date_Active
1251: from PER_ASSIGNMENTS_F a,
1252: PAY_ELEMENT_ENTRIES_F b,
1253: PAY_ELEMENT_LINKS_F c,
1254: PAY_ELEMENT_TYPES_F d,
1255: PSP_ELEMENT_TYPE_ACCOUNTS e

Line 1317: from PER_ASSIGNMENTS_F a,

1313: select DISTINCT c.ASSIGNMENT_ID,
1314: c.ELEMENT_GROUP_ID,
1315: d.SCHEDULE_BEGIN_DATE,
1316: d.SCHEDULE_END_DATE
1317: from PER_ASSIGNMENTS_F a,
1318: PSP_SCHEDULES b,
1319: PSP_SCHEDULE_HIERARCHY c,
1320: PSP_SCHEDULE_LINES d,
1321: PSP_GROUP_ELEMENT_LIST e