APPS.PAY_BALANCE_UPLOAD dependencies on PAY_PAYROLL_ACTIONS

Line 323: (payroll_action_id pay_payroll_actions.payroll_action_id%type

319: ,include_adj_rule pay_legislation_rules.rule_mode%type
320: );
321:
322: type g_payroll_action_rec_type is record
323: (payroll_action_id pay_payroll_actions.payroll_action_id%type
324: ,effective_date pay_payroll_actions.effective_date%type
325: ,payroll_id number
326: );
327:

Line 324: ,effective_date pay_payroll_actions.effective_date%type

320: );
321:
322: type g_payroll_action_rec_type is record
323: (payroll_action_id pay_payroll_actions.payroll_action_id%type
324: ,effective_date pay_payroll_actions.effective_date%type
325: ,payroll_id number
326: );
327:
328: type g_payroll_action_tab_type is table of g_payroll_action_rec_type

Line 3467: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)

3463: 10);
3464: select /*+ ORDERED
3465: USE_NL(pbl ppa pbf paa rr rrv)
3466: INDEX(pbl PAY_BALANCE_BATCH_LINES_N51)
3467: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
3468: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
3469: INDEX(rr PAY_RUN_RESULTS_N50)
3470: INDEX(rrv PAY_RUN_RESULT_VALUES_N50)
3471: INDEX(pbf PAY_BALANCE_FEEDS_F_N2) */

Line 3477: pay_payroll_actions ppa,

3473: paa.assignment_action_id),16))
3474: into l_asg_act_id
3475: from
3476: pay_balance_batch_lines pbl,
3477: pay_payroll_actions ppa,
3478: pay_assignment_actions paa,
3479: pay_run_results rr,
3480: pay_run_result_values rrv,
3481: pay_balance_feeds_f pbf

Line 4595: from pay_assignment_actions AA, pay_payroll_actions PAA

4591: (
4592: p_assignment_id number
4593: ) is
4594: select AA.payroll_action_id
4595: from pay_assignment_actions AA, pay_payroll_actions PAA
4596: where AA.assignment_id = p_assignment_id
4597: and PAA.payroll_action_id = AA.payroll_action_id
4598: and PAA.action_type <> 'BEE';
4599: --

Line 5574: from pay_payroll_actions ppa,

5570: cursor csr_get_payroll_actions (p_payroll_id in number,
5571: p_assignment_id in number)
5572: is
5573: select ppa.payroll_action_id
5574: from pay_payroll_actions ppa,
5575: pay_assignment_actions paa
5576: where ppa.payroll_id = p_payroll_id
5577: and ppa.action_type <> 'I'
5578: and paa.payroll_action_id = ppa.payroll_action_id

Line 5741: pay_payroll_actions ppa

5737: is
5738: select
5739: distinct ppa.payroll_action_id
5740: from
5741: pay_payroll_actions ppa
5742: ,pay_balance_batch_lines pbbl
5743: where
5744: ppa.action_status <> 'C'
5745: and ppa.payroll_action_id = pbbl.payroll_action_id