APPS.PAY_BALANCE_UPLOAD dependencies on PAY_PAYROLL_ACTIONS

Line 325: (payroll_action_id pay_payroll_actions.payroll_action_id%type

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

Line 326: ,effective_date pay_payroll_actions.effective_date%type

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

Line 2069: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

2065: procedure wcb_context_setup
2066: (
2067: p_asg_id in number,
2068: p_business_group_id in number,
2069: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2070: p_tax_unit_id in number,
2071: p_effective_date in date,
2072: p_message out nocopy varchar2
2073: ) is

Line 3760: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)

3756: 10);
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) */

Line 3770: pay_payroll_actions ppa,

3766: paa.assignment_action_id),16))
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

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 5867: from pay_payroll_actions ppa,

5863: cursor csr_get_payroll_actions (p_payroll_id in number,
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

Line 6034: pay_payroll_actions ppa

6030: is
6031: select
6032: distinct ppa.payroll_action_id
6033: from
6034: pay_payroll_actions ppa
6035: ,pay_balance_batch_lines pbbl
6036: where
6037: ppa.action_status <> 'C'
6038: and ppa.payroll_action_id = pbbl.payroll_action_id