APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 6: TYPE t_asg_set_amnds IS TABLE OF hr_assignment_set_amendments.include_or_exclude%TYPE

2: /* $Header: pyieeoyc.pkb 120.6 2011/01/04 14:15:12 abraghun noship $ */
3: vCtr NUMBER;
4:
5: /*6876894*/
6: TYPE t_asg_set_amnds IS TABLE OF hr_assignment_set_amendments.include_or_exclude%TYPE
7: INDEX BY BINARY_INTEGER;
8: l_tab_asg_set_amnds t_asg_set_amnds;
9:
10:

Line 74: FROM hr_assignment_set_amendments

70: CURSOR csr_get_asg_amnd(c_asg_set_id NUMBER)
71: IS
72: SELECT assignment_id, NVL(include_or_exclude
73: ,'I') include_or_exclude
74: FROM hr_assignment_set_amendments
75: WHERE assignment_set_id = c_asg_set_id;
76: l_proc_step NUMBER(38, 10) := 0;
77: l_asg_set_amnds csr_get_asg_amnd%ROWTYPE;
78: l_tab_asg_set_amnds t_asg_set_amnds;

Line 354: FROM HR_ASSIGNMENT_SET_AMENDMENTS HR_ASG

350: /*6876894*/
351: /* removing the check with the assignment set ammendments and checking later for both ammendment set criteria
352: and ammendments for a particular assignment set id*/
353: /* AND (p_assignment_set_id IS NULL OR EXISTS (SELECT ' '
354: FROM HR_ASSIGNMENT_SET_AMENDMENTS HR_ASG
355: WHERE HR_ASG.ASSIGNMENT_SET_ID=NVL(p_assignment_set_id, HR_ASG.ASSIGNMENT_SET_ID)
356: AND HR_ASG.ASSIGNMENT_ID=PAA.ASSIGNMENT_ID ))
357: */
358: and PAPF.payroll_id = paf.payroll_id