APPS.PAY_IE_P60XML 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: pyiep60p.pkb 120.30.12020000.6 2013/02/12 11:36:15 rsahai ship $ */
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 39: FROM hr_assignment_set_amendments

35: CURSOR csr_get_asg_amnd(c_asg_set_id NUMBER)
36: IS
37: SELECT assignment_id, NVL(include_or_exclude
38: ,'I') include_or_exclude
39: FROM hr_assignment_set_amendments
40: WHERE assignment_set_id = c_asg_set_id;
41: l_proc_step NUMBER(38, 10) := 0;
42: l_asg_set_amnds csr_get_asg_amnd%ROWTYPE;
43: l_tab_asg_set_amnds t_asg_set_amnds;

Line 442: FROM HR_ASSIGNMENT_SET_AMENDMENTS HR_ASG

438: /*6876894*/
439: /* removing the check with the assignment set ammendments and checking later for both ammendment set criteria
440: and ammendments for a particular assignment set id*/
441: /* AND (p_assignment_set_id IS NULL OR EXISTS (SELECT ' '
442: FROM HR_ASSIGNMENT_SET_AMENDMENTS HR_ASG
443: WHERE HR_ASG.ASSIGNMENT_SET_ID=NVL(p_assignment_set_id, HR_ASG.ASSIGNMENT_SET_ID)
444: AND HR_ASG.ASSIGNMENT_ID=PAA.ASSIGNMENT_ID ))
445: */
446: and PAPF.payroll_id = paf.payroll_id