APPS.HR_ASSIGNMENT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 2412: HR_ASSIGNMENT_SET_AMENDMENTS

2408: PER_LETTER_REQUEST_LINES
2409: PAY_COST_ALLOCATIONS_F
2410: PER_ASSIGNMENT_EXTRA_INFO
2411: PAY_PERSONAL_PAYMENT_METHODS_F
2412: HR_ASSIGNMENT_SET_AMENDMENTS
2413: PAY_ASSIGNMENT_ACTIONS
2414: PER_COBRA_COV_ENROLLMENTS
2415: PER_COBRA_COVERAGE_BENEFITS_F
2416: OTA_DELEGATE_BOOKINGS (per_ota_predel_validation.ota_predel_asg_validation)

Line 2717: from hr_assignment_set_amendments asa

2713: into p_del_flag
2714: from sys.dual
2715: where exists (
2716: select null
2717: from hr_assignment_set_amendments asa
2718: where asa.assignment_id = p_assignment_id
2719: and asa.include_or_exclude = 'I'
2720: and not exists (
2721: select null

Line 2722: from hr_assignment_set_amendments asa2

2718: where asa.assignment_id = p_assignment_id
2719: and asa.include_or_exclude = 'I'
2720: and not exists (
2721: select null
2722: from hr_assignment_set_amendments asa2
2723: where asa2.assignment_set_id = asa.assignment_set_id
2724: and asa2.assignment_id <> asa.assignment_id)
2725: );
2726: EXCEPTION

Line 2861: HR_ASSIGNMENT_SET_AMENDMENTS

2857: Performs Third Party Delete on data that is not checked in
2858: del_ref_in_check. Removes data from the following tables
2859:
2860: For 'ZAP'
2861: HR_ASSIGNMENT_SET_AMENDMENTS
2862: PER_ASSIGNMENT_BUDGET_VALUES_F
2863: PER_SPINAL_POINT_PLACEMENTS_F
2864: PER_PAY_PROPOSALS
2865:

Line 3451: FROM HR_ASSIGNMENT_SET_AMENDMENTS

3447: into p_del_flag
3448: FROM SYS.DUAL
3449: WHERE EXISTS
3450: (SELECT NULL
3451: FROM HR_ASSIGNMENT_SET_AMENDMENTS
3452: WHERE ASSIGNMENT_ID = p_assignment_id);
3453: --
3454: EXCEPTION
3455: WHEN NO_DATA_FOUND THEN NULL;

Line 3461: DELETE FROM HR_ASSIGNMENT_SET_AMENDMENTS

3457: --
3458: IF p_del_flag = 'Y' THEN
3459: --
3460: hr_utility.set_location('hr_assignment.delete_ass_ref_int',6);
3461: DELETE FROM HR_ASSIGNMENT_SET_AMENDMENTS
3462: WHERE ASSIGNMENT_ID = p_assignment_id;
3463: END IF;
3464: --
3465: --