APPS.PAY_BAL_ADJUST dependencies on PAY_ASSIGNMENT_ACTIONS

Line 112: from pay_assignment_actions act

108:
109: -- Look for an existing assignment action.
110: select act.assignment_action_id
111: into l_assactid
112: from pay_assignment_actions act
113: where act.payroll_action_id = p_info.batchid
114: and nvl(act.tax_unit_id, g_number) = nvl(l_tax_unit_id, g_number)
115: and act.assignment_id = p_info.asgid;
116:

Line 141: from pay_assignment_actions act

137: -- Get the action id of that created.
138: hr_utility.set_location('insert_assact', 20);
139: select act.assignment_action_id
140: into l_assactid
141: from pay_assignment_actions act
142: where act.payroll_action_id = p_info.batchid
143: and act.assignment_id = p_info.asgid
144: and nvl(act.tax_unit_id, g_number) = nvl(l_tax_unit_id, g_number);
145:

Line 148: update pay_assignment_actions

144: and nvl(act.tax_unit_id, g_number) = nvl(l_tax_unit_id, g_number);
145:
146: hr_utility.trace('(new) l_assactid : ' || l_assactid);
147:
148: update pay_assignment_actions
149: set chunk_number = g_curr_chunk_no
150: where assignment_action_id= l_assactid;
151:
152: g_no_asg_act := g_no_asg_act + 1;

Line 437: from pay_assignment_actions

433: */
434:
435: select tax_unit_id
436: into tax_unit
437: from pay_assignment_actions
438: where assignment_action_id = p_assactid;
439: --
440: hrassact.set_action_context (p_assactid,
441: p_run_result_id,

Line 1194: from pay_assignment_actions

1190: --
1191: cursor get_rb_asg_actions(p_pact_id number)
1192: is
1193: select assignment_action_id
1194: from pay_assignment_actions
1195: where payroll_action_id = p_pact_id;
1196: --
1197: l_info info_r;
1198: l_timperid number;

Line 1253: from pay_assignment_actions act

1249:
1250: -- One item of information.
1251: select count(*)
1252: into l_processed
1253: from pay_assignment_actions act
1254: where act.payroll_action_id = l_info.batchid
1255: and act.action_status = 'C';
1256:
1257: hr_utility.trace('Asgs processed : ' || l_processed);

Line 1303: from pay_assignment_actions

1299: begin
1300:
1301: select assignment_id
1302: into l_assignment_id
1303: from pay_assignment_actions
1304: where assignment_action_id=p_assignment_action_id;
1305:
1306: select ee.element_entry_id,
1307: ee.element_link_id,

Line 1495: from pay_assignment_actions

1491: p_context_value := p_assignment_action_id;
1492: elsif (p_inp_name = 'TAX_UNIT_ID') then
1493: select tax_unit_id
1494: into p_context_value
1495: from pay_assignment_actions
1496: where assignment_action_id = p_assignment_action_id;
1497: elsif (p_inp_name = 'ELEMENT_ENTRY_ID') then
1498: p_context_value := p_entry_id;
1499: elsif (p_inp_name = 'ELEMENT_TYPE_ID') then

Line 1506: from pay_assignment_actions

1502: p_context_value := p_bus_grp;
1503: elsif (p_inp_name = 'PAYROLL_ACTION_ID') then
1504: select payroll_action_id
1505: into p_context_value
1506: from pay_assignment_actions
1507: where assignment_action_id =p_assignment_action_id;
1508: elsif (p_inp_name = 'DATE_EARNED') then
1509: p_context_value := fnd_date.date_to_canonical(p_effdate);
1510: end if;