APPS.PAY_BALANCE_UPLOAD dependencies on PAY_ASSIGNMENT_ACTIONS

Line 2081: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

2077: l_jur_code fnd_lookup_values.lookup_code%type;
2078: l_formula_id ff_formulas_f.formula_id%type;
2079: l_wcb_acc_number pay_element_entry_values_f.screen_entry_value%type := null;
2080: l_wcb_rate_code pay_element_entry_values_f.screen_entry_value%type := null;
2081: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2082:
2083: CURSOR c_assignment_jur
2084: IS
2085: SELECT LOC.region_1

Line 2280: select assignment_action_id into l_assignment_action_id from pay_assignment_actions where

2276: END IF;
2277:
2278: begin
2279: hr_utility.trace('Updating pay_action_contexts');
2280: select assignment_action_id into l_assignment_action_id from pay_assignment_actions where
2281: payroll_action_id = p_payroll_action_id and assignment_id = p_asg_id;
2282: hr_utility.trace('l_assignment_action_id '||l_assignment_action_id);
2283: INSERT INTO pay_action_contexts
2284: (ASSIGNMENT_ACTION_ID

Line 3432: p_asg_act_id in pay_assignment_actions.assignment_action_id%TYPE,

3428: p_bal_type_id in pay_balance_batch_lines.balance_type_id%TYPE,
3429: p_bal_dimension_id in pay_balance_batch_lines.balance_dimension_id%TYPE,
3430: p_value in pay_balance_batch_lines.value%TYPE,
3431: p_assignment_id in pay_balance_batch_lines.assignment_id%TYPE,
3432: p_asg_act_id in pay_assignment_actions.assignment_action_id%TYPE,
3433: p_tax_unit_id in number,
3434: p_jurisdiction_code in pay_balance_batch_lines.jurisdiction_code%TYPE
3435: default NULL,
3436: p_source_id in number,

Line 3692: from pay_assignment_actions paa

3688: cursor csr_get_asg_act (p_act_id in number,
3689: p_asg_id in number)
3690: is
3691: select paa.assignment_action_id
3692: from pay_assignment_actions paa
3693: where paa.assignment_id = p_asg_id
3694: and paa.payroll_action_id = p_act_id;
3695: --
3696: --

Line 3761: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)

3757: select /*+ ORDERED
3758: USE_NL(pbl ppa pbf paa rr rrv)
3759: INDEX(pbl PAY_BALANCE_BATCH_LINES_N51)
3760: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
3761: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
3762: INDEX(rr PAY_RUN_RESULTS_N50)
3763: INDEX(rrv PAY_RUN_RESULT_VALUES_N50)
3764: INDEX(pbf PAY_BALANCE_FEEDS_F_N2) */
3765: to_number(substr(max(lpad(paa.action_sequence,15,'0')||

Line 3771: pay_assignment_actions paa,

3767: into l_asg_act_id
3768: from
3769: pay_balance_batch_lines pbl,
3770: pay_payroll_actions ppa,
3771: pay_assignment_actions paa,
3772: pay_run_results rr,
3773: pay_run_result_values rrv,
3774: pay_balance_feeds_f pbf
3775: where pbl.batch_id = p_glbl_data_rec.batch_id

Line 4888: from pay_assignment_actions AA, pay_payroll_actions PAA

4884: (
4885: p_assignment_id number
4886: ) is
4887: select AA.payroll_action_id
4888: from pay_assignment_actions AA, pay_payroll_actions PAA
4889: where AA.assignment_id = p_assignment_id
4890: and PAA.payroll_action_id = AA.payroll_action_id
4891: and PAA.action_type <> 'BEE';
4892: --

Line 5868: pay_assignment_actions paa

5864: p_assignment_id in number)
5865: is
5866: select ppa.payroll_action_id
5867: from pay_payroll_actions ppa,
5868: pay_assignment_actions paa
5869: where ppa.payroll_id = p_payroll_id
5870: and ppa.action_type <> 'I'
5871: and paa.payroll_action_id = ppa.payroll_action_id
5872: and paa.assignment_id = p_assignment_id;