DBA Data[Home] [Help]

APPS.HRASSACT dependencies on PAY_ALL_PAYROLLS_F

Line 178: pay_all_payrolls_f. Performance

174: setting the jurisdiction code
175: in sparse mode.
176: 04-NOV-2003 alogue 115.84 3176709 Use of per_business_groups_perf,
177: per_all_people_f and
178: pay_all_payrolls_f. Performance
179: fix to seqper cursors.
180: 03-NOV-2003 tbattoo 115.83 support for sparse matrix and
181: pay_latest_balances table
182: 17-OCT-2003 alogue 115.82 Tuned get_rr_values cursor

Line 632: payroll_name pay_all_payrolls_f.payroll_name%type,

628: action_type pay_payroll_actions.action_type%type,
629: sequenced_flag boolean,
630: action_date date,
631: current_date date, -- this is sysdate.
632: payroll_name pay_all_payrolls_f.payroll_name%type,
633: bg_name hr_organization_units.name%type,
634: independent_periods_flag boolean);
635: --
636: c_eot constant date := to_date('31/12/4712','DD/MM/YYYY');

Line 1128: pay_all_payrolls_f pay,

1124: p_pact_rec.current_date,
1125: p_pact_rec.payroll_name,
1126: p_pact_rec.bg_name
1127: from pay_payroll_actions pac,
1128: pay_all_payrolls_f pay,
1129: per_business_groups_perf grp,
1130: hr_lookups hrl
1131: where pac.payroll_action_id = p_pact_rec.pact_id
1132: and hrl.lookup_code = pac.action_type