APPS.PAY_MWS_MAGTAPE_REPORTING dependencies on PAY_ASSIGNMENT_ACTIONS

Line 137: FROM pay_assignment_actions aa

133: tax_unit_id updated yet. */
134:
135: CURSOR csr_assignment_action IS
136: SELECT aa.assignment_action_id
137: FROM pay_assignment_actions aa
138: WHERE aa.payroll_action_id = p_payroll_action_id
139: AND aa.assignment_id = p_assignment_id
140: AND aa.tax_unit_id IS NULL;
141:

Line 144: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

140: AND aa.tax_unit_id IS NULL;
141:
142: /* Local variables. */
143:
144: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
145: l_serial_no varchar2(30);
146:
147: begin
148:

Line 159: PAY_ASSIGNMENT_ACTIONS table We will also store the effective end date

155: any balances based on the assignment action is correct. */
156:
157: /* First Round up the wages to the nearest dollar and convert it to char
158: so that it can be stored in the serial number coulmn of the
159: PAY_ASSIGNMENT_ACTIONS table We will also store the effective end date
160: of the assignment along with the wages for the assignment because we
161: may have a person having 2 assignments for the same organization and
162: and GRE with different effective start and end dates (falling within
163: the same quarter e.g. one having start dt = 01-jan-1990

Line 187: update pay_assignment_actions aa

183: open csr_assignment_action;
184: fetch csr_assignment_action INTO l_assignment_action_id;
185: close csr_assignment_action;
186:
187: update pay_assignment_actions aa
188: set aa.tax_unit_id = p_tax_unit_id,
189: aa.serial_number = l_serial_no
190: where aa.assignment_action_id = l_assignment_action_id;
191:

Line 204: l_asg_action_id pay_assignment_actions.assignment_action_id%type;

200:
201: procedure do_asg_break_processing(p_payroll_action_id in number,
202: p_ctr in out nocopy number,
203: end_of_cursor in boolean) is
204: l_asg_action_id pay_assignment_actions.assignment_action_id%type;
205: begin
206:
207: if (p_ctr = 4) then /* We have 3 records for the assg */
208:

Line 321: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

317: l_end_date2 date;
318: l_end_date3 date;
319: l_payroll_action_created boolean := false;
320: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
321: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
322:
323:
324: /* Variable holding the balance to be tested. */
325: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

Line 770: update pay_assignment_actions AA

766: update pay_payroll_actions pa
767: set PA.action_status = 'M'
768: where PA.payroll_action_id = p_payroll_action_id;
769:
770: update pay_assignment_actions AA
771: set AA.action_status = 'M'
772: where AA.payroll_action_id = p_payroll_action_id;
773:
774: commit;

Line 800: update pay_assignment_actions AA

796: l_quarter_start,
797: l_quarter_end,
798: l_business_group_id);
799:
800: update pay_assignment_actions AA
801: set AA.action_status = 'C'
802: where AA.payroll_action_id = p_payroll_action_id;
803:
804: commit;