DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PER_PAY_PROPOSALS

Line 2827: PER_PAY_PROPOSALS

2823: For 'ZAP'
2824: HR_ASSIGNMENT_SET_AMENDMENTS
2825: PER_ASSIGNMENT_BUDGET_VALUES_F
2826: PER_SPINAL_POINT_PLACEMENTS_F
2827: PER_PAY_PROPOSALS
2828:
2829: For 'END' (performs a date effective delete)
2830: PER_SPINAL_POINT_PLACEMENTS_F
2831: PER_ASSIGNMENT_BUDGET_VALUES_F

Line 3462: FROM PER_PAY_PROPOSALS

3458: into p_del_flag
3459: FROM SYS.DUAL
3460: WHERE EXISTS
3461: (SELECT NULL
3462: FROM PER_PAY_PROPOSALS
3463: WHERE ASSIGNMENT_ID = p_assignment_id);
3464: --
3465: EXCEPTION
3466: WHEN NO_DATA_FOUND THEN NULL;

Line 3472: DELETE FROM PER_PAY_PROPOSALS

3468: --
3469: IF p_del_flag = 'Y' THEN
3470: --
3471: hr_utility.set_location('hr_assignment.delete_ass_ref_int',12);
3472: DELETE FROM PER_PAY_PROPOSALS
3473: WHERE ASSIGNMENT_ID = p_assignment_id;
3474: END IF;
3475: --
3476: /* This is being changed for Bug# 785427 */