APPS.PAY_SE_CWCR dependencies on PAY_ACTION_INFORMATION

Line 67: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;

63: /* Start of declaration*/
64:
65: -- Variables needed for the report
66: l_counter number := 0;
67: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;
68: l_digit1 NUMBER(1);
69: l_digit2 NUMBER(1);
70: l_digit3 NUMBER(1);
71: l_digit4 NUMBER(1);

Line 85: Cursor csr_cwcr_header_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)

81: /* End of declaration*/
82:
83: /* Cursors */
84:
85: Cursor csr_cwcr_header_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)
86: IS
87: SELECT *
88: FROM PAY_ACTION_INFORMATION
89: WHERE ACTION_CONTEXT_TYPE = 'PA'

Line 88: FROM PAY_ACTION_INFORMATION

84:
85: Cursor csr_cwcr_header_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)
86: IS
87: SELECT *
88: FROM PAY_ACTION_INFORMATION
89: WHERE ACTION_CONTEXT_TYPE = 'PA'
90: AND ACTION_CONTEXT_ID = csr_v_pa_id
91: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT DETAILS'
92: AND ACTION_INFORMATION1='PYSECWCA';

Line 95: Cursor csr_cwcr_b1(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE )

91: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT DETAILS'
92: AND ACTION_INFORMATION1='PYSECWCA';
93:
94:
95: Cursor csr_cwcr_b1(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE )
96: IS
97: SELECT *
98: FROM PAY_ACTION_INFORMATION
99: WHERE ACTION_CONTEXT_TYPE = 'PA'

Line 98: FROM PAY_ACTION_INFORMATION

94:
95: Cursor csr_cwcr_b1(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE )
96: IS
97: SELECT *
98: FROM PAY_ACTION_INFORMATION
99: WHERE ACTION_CONTEXT_TYPE = 'PA'
100: AND ACTION_CONTEXT_ID = csr_v_pa_id
101: AND ACTION_INFORMATION1='PYSECWCA'
102: AND ACTION_INFORMATION2='CWC1';

Line 106: Cursor csr_cwcr_b2(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE )

102: AND ACTION_INFORMATION2='CWC1';
103:
104: rg_cwcr_b1 csr_cwcr_b1%rowtype;
105:
106: Cursor csr_cwcr_b2(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE )
107: IS
108: SELECT *
109: FROM PAY_ACTION_INFORMATION
110: WHERE ACTION_CONTEXT_TYPE = 'PA'

Line 109: FROM PAY_ACTION_INFORMATION

105:
106: Cursor csr_cwcr_b2(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE )
107: IS
108: SELECT *
109: FROM PAY_ACTION_INFORMATION
110: WHERE ACTION_CONTEXT_TYPE = 'PA'
111: AND ACTION_CONTEXT_ID = csr_v_pa_id
112: AND ACTION_INFORMATION1='PYSECWCA'
113: AND ACTION_INFORMATION2='CWC2'

Line 116: Cursor csr_cwcr_b3(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE, csr_v_month NUMBER, csr_v_year NUMBER )

112: AND ACTION_INFORMATION1='PYSECWCA'
113: AND ACTION_INFORMATION2='CWC2'
114: ORDER BY ACTION_INFORMATION10 asc , ACTION_INFORMATION3 asc ;
115:
116: Cursor csr_cwcr_b3(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE, csr_v_month NUMBER, csr_v_year NUMBER )
117: IS
118: SELECT *
119: FROM PAY_ACTION_INFORMATION
120: WHERE ACTION_CONTEXT_TYPE = 'PA'

Line 119: FROM PAY_ACTION_INFORMATION

115:
116: Cursor csr_cwcr_b3(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE, csr_v_month NUMBER, csr_v_year NUMBER )
117: IS
118: SELECT *
119: FROM PAY_ACTION_INFORMATION
120: WHERE ACTION_CONTEXT_TYPE = 'PA'
121: AND ACTION_CONTEXT_ID = csr_v_pa_id
122: AND ACTION_INFORMATION1='PYSECWCA'
123: AND ACTION_INFORMATION2='CWC3'

Line 127: Cursor csr_cwcr_b4(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE, csr_v_month NUMBER, csr_v_year NUMBER )

123: AND ACTION_INFORMATION2='CWC3'
124: AND ACTION_INFORMATION3 = csr_v_month
125: AND ACTION_INFORMATION10 = csr_v_year ;
126:
127: Cursor csr_cwcr_b4(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE, csr_v_month NUMBER, csr_v_year NUMBER )
128: IS
129: SELECT *
130: FROM PAY_ACTION_INFORMATION
131: WHERE ACTION_CONTEXT_TYPE = 'PA'

Line 130: FROM PAY_ACTION_INFORMATION

126:
127: Cursor csr_cwcr_b4(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE, csr_v_month NUMBER, csr_v_year NUMBER )
128: IS
129: SELECT *
130: FROM PAY_ACTION_INFORMATION
131: WHERE ACTION_CONTEXT_TYPE = 'PA'
132: AND ACTION_CONTEXT_ID = csr_v_pa_id
133: AND ACTION_INFORMATION1='PYSECWCA'
134: AND ACTION_INFORMATION2='CWC4'

Line 138: Cursor csr_cwcr_b5(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE, csr_v_month NUMBER, csr_v_year NUMBER )

134: AND ACTION_INFORMATION2='CWC4'
135: AND ACTION_INFORMATION3 = csr_v_month
136: AND ACTION_INFORMATION10 = csr_v_year ;
137:
138: Cursor csr_cwcr_b5(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE, csr_v_month NUMBER, csr_v_year NUMBER )
139: IS
140: SELECT *
141: FROM PAY_ACTION_INFORMATION
142: WHERE ACTION_CONTEXT_TYPE = 'PA'

Line 141: FROM PAY_ACTION_INFORMATION

137:
138: Cursor csr_cwcr_b5(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE, csr_v_month NUMBER, csr_v_year NUMBER )
139: IS
140: SELECT *
141: FROM PAY_ACTION_INFORMATION
142: WHERE ACTION_CONTEXT_TYPE = 'PA'
143: AND ACTION_CONTEXT_ID = csr_v_pa_id
144: AND ACTION_INFORMATION1='PYSECWCA'
145: AND ACTION_INFORMATION2='CWC5'