APPS.PAY_MISC_DYT_INCIDENT_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 32: from per_all_assignments_f

28: IS
29: --
30: cursor asgcur (p_person_id number) is
31: select distinct assignment_id
32: from per_all_assignments_f
33: where person_id = p_person_id;
34: --
35: l_process_event_id number;
36: l_object_version_number number;

Line 188: from per_all_assignments_f

184: is
185: --
186: cursor asgcur (p_person_id number) is
187: select distinct assignment_id
188: from per_all_assignments_f
189: where person_id = p_person_id;
190:
191: l_proc varchar2(240) := g_package||'.per_performance_reviews_aru';
192: begin

Line 595: from per_all_assignments_f

591: is
592: --
593: cursor asgcur (p_person_id number) is
594: select distinct assignment_id
595: from per_all_assignments_f
596: where person_id = p_person_id;
597: --
598: l_process_event_id number;
599: l_object_version_number number;

Line 677: from per_all_assignments_f

673: is
674: --
675: cursor asgcur (p_person_id number) is
676: select distinct assignment_id
677: from per_all_assignments_f
678: where person_id = p_person_id;
679: --
680: l_process_event_id number;
681: l_object_version_number number;

Line 854: from per_all_assignments_f

850: is
851: --
852: cursor asgcur (p_person_id number) is
853: select distinct assignment_id
854: from per_all_assignments_f
855: where person_id = p_person_id;
856: --
857: l_proc varchar2(240) := g_package||'.per_appraisals_aru';
858: begin

Line 1415: from per_all_assignments_f

1411: is
1412: --
1413: cursor asgcur (p_person_id number) is
1414: select distinct assignment_id
1415: from per_all_assignments_f
1416: where person_id = p_person_id;
1417: --
1418: l_process_event_id number;
1419: l_object_version_number number;

Line 1498: from per_all_assignments_f

1494: IS
1495: --
1496: cursor asgcur (p_person_id number) is
1497: select distinct assignment_id
1498: from per_all_assignments_f
1499: where person_id = p_person_id;
1500: --
1501: l_process_event_id number;
1502: l_object_version_number number;

Line 1638: from per_all_assignments_f

1634: is
1635: --
1636: cursor asgcur (p_person_id number) is
1637: select distinct assignment_id
1638: from per_all_assignments_f
1639: where person_id = p_person_id;
1640: --
1641: l_proc varchar2(240) := g_package||'.per_person_type_usages_f_aru';
1642: --

Line 1990: from per_all_assignments_f

1986: is
1987: --
1988: cursor asgcur (p_person_id number) is
1989: select distinct assignment_id
1990: from per_all_assignments_f
1991: where person_id = p_person_id;
1992: --
1993: l_process_event_id number;
1994: l_object_version_number number;

Line 2797: from per_all_assignments_f

2793: is
2794: --
2795: cursor asgcur (p_person_id number) is
2796: select distinct assignment_id
2797: from per_all_assignments_f
2798: where person_id = p_person_id;
2799: --
2800: l_process_event_id number;
2801: l_object_version_number number;

Line 3011: from per_all_assignments_f

3007: is
3008: --
3009: cursor asgcur (p_person_id number) is
3010: select distinct assignment_id
3011: from per_all_assignments_f
3012: where person_id = p_person_id;
3013: l_proc varchar2(240);
3014:
3015: begin

Line 3790: from per_all_assignments_f

3786: ) IS
3787: --
3788: cursor asgcur (p_person_id number) is
3789: select distinct assignment_id
3790: from per_all_assignments_f
3791: where person_id = p_person_id
3792: and primary_flag = 'Y';
3793: --
3794: l_proc varchar2(240) := g_package||'.per_absence_attendances_aru';

Line 4235: from per_all_assignments_f

4231: IS
4232: --
4233: cursor asgcur (p_person_id number) is
4234: select distinct assignment_id
4235: from per_all_assignments_f
4236: where person_id = p_person_id
4237: and primary_flag = 'Y';
4238: --
4239: l_process_event_id number;

Line 4309: from per_all_assignments_f

4305: IS
4306: --
4307: cursor asgcur (p_person_id number) is
4308: select distinct assignment_id
4309: from per_all_assignments_f
4310: where person_id = p_person_id
4311: and primary_flag = 'Y';
4312: --
4313: l_process_event_id number;