[Home] [Help]
104: ,action_status pay_assignment_actions.action_status%type
105: ,action_sequence number
106: -- Payroll action information
107: ,payroll_action_id number
108: ,action_type pay_payroll_actions.action_type%type
109: ,business_group_id number
110: ,action_population_status pay_payroll_actions.action_population_status%type
111: ,ppa_action_status pay_payroll_actions.action_status%type
112: ,effective_date date
106: -- Payroll action information
107: ,payroll_action_id number
108: ,action_type pay_payroll_actions.action_type%type
109: ,business_group_id number
110: ,action_population_status pay_payroll_actions.action_population_status%type
111: ,ppa_action_status pay_payroll_actions.action_status%type
112: ,effective_date date
113: ,date_earned date
114: -- Assignment information
107: ,payroll_action_id number
108: ,action_type pay_payroll_actions.action_type%type
109: ,business_group_id number
110: ,action_population_status pay_payroll_actions.action_population_status%type
111: ,ppa_action_status pay_payroll_actions.action_status%type
112: ,effective_date date
113: ,date_earned date
114: -- Assignment information
115: ,assignment_id number
173: -- Assignment information
174: ,act.assignment_id
175: ,act.end_date rollup_date
176: from
177: pay_payroll_actions pac
178: ,pay_assignment_actions act
179: where
180: act.assignment_action_id = p_assignment_action_id
181: and pac.payroll_action_id = act.payroll_action_id
268: ,pbg.legislation_code
269: ,ppa.effective_date
270: ,ppa.balance_set_id
271: from
272: pay_payroll_actions ppa
273: ,per_business_groups_perf pbg
274: where
275: ppa.payroll_action_id = p_purge_action_id
276: and pbg.business_group_id = ppa.business_group_id
438: pay_balance_feeds_f pbf
439: ,pay_input_values_f piv
440: ,pay_run_results prr
441: ,pay_assignment_actions paa
442: ,pay_payroll_actions ppa
443: ,pay_assignment_actions purge_paa
444: ,pay_run_result_values prrv
445: where
446: pbf.balance_type_id = p_baltypid
582: ,paa.assignment_id
583: ,paa.end_date
584: from
585: pay_assignment_actions paa
586: ,pay_payroll_actions ppa
587: where
588: paa.assignment_action_id = p_assignment_action_id
589: and ppa.payroll_action_id = paa.payroll_action_id
590: ;
776: ffc.context_name,
777: to_char(paa.tax_unit_id)
778: from ff_contexts ffc,
779: pay_assignment_actions paa,
780: pay_payroll_actions ppa
781: where ffc.context_name = 'TAX_UNIT_ID'
782: and paa.assignment_id = p_assignment_id
783: and paa.tax_unit_id is not null
784: and ppa.payroll_action_id = paa.payroll_action_id
799: ffc.context_name,
800: to_char(act.tax_unit_id) context_value
801: from ff_contexts ffc,
802: pay_assignment_actions act,
803: pay_payroll_actions pac
804: where act.assignment_id = p_assignment_id
805: and pac.payroll_action_id = act.payroll_action_id
806: and pac.effective_date <= p_purge_date
807: and act.tax_unit_id is not null
812: ctx.context_value
813: from pay_action_contexts ctx,
814: ff_contexts ffc,
815: pay_assignment_actions act,
816: pay_payroll_actions pac
817: where ctx.assignment_id = p_assignment_id
818: and ffc.context_id = ctx.context_id
819: and ffc.context_name in ('JURISDICTION_CODE',
820: 'ORIGINAL_ENTRY_ID',
1003: --
1004: l_creating_new_action := true;
1005:
1006: -- Obtain the payroll_action_id.
1007: select pay_payroll_actions_s.nextval
1008: into l_new_payactid
1009: from dual;
1010:
1011: insert into pay_payroll_actions (
1007: select pay_payroll_actions_s.nextval
1008: into l_new_payactid
1009: from dual;
1010:
1011: insert into pay_payroll_actions (
1012: payroll_action_id,
1013: action_type,
1014: business_group_id,
1015: payroll_id,