DBA Data[Home] [Help]

APPS.HRASSACT dependencies on PAY_ALL_PAYROLLS_F

Line 210: pay_all_payrolls_f. Performance

206: setting the jurisdiction code
207: in sparse mode.
208: 04-NOV-2003 alogue 115.84 3176709 Use of per_business_groups_perf,
209: per_all_people_f and
210: pay_all_payrolls_f. Performance
211: fix to seqper cursors.
212: 03-NOV-2003 tbattoo 115.83 support for sparse matrix and
213: pay_latest_balances table
214: 17-OCT-2003 alogue 115.82 Tuned get_rr_values cursor

Line 664: payroll_name pay_all_payrolls_f.payroll_name%type,

660: action_type pay_payroll_actions.action_type%type,
661: sequenced_flag boolean,
662: action_date date,
663: current_date date, -- this is sysdate.
664: payroll_name pay_all_payrolls_f.payroll_name%type,
665: bg_name hr_organization_units.name%type,
666: independent_periods_flag boolean);
667: --
668: c_eot constant date := to_date('31/12/4712','DD/MM/YYYY');

Line 1160: pay_all_payrolls_f pay,

1156: p_pact_rec.current_date,
1157: p_pact_rec.payroll_name,
1158: p_pact_rec.bg_name
1159: from pay_payroll_actions pac,
1160: pay_all_payrolls_f pay,
1161: per_business_groups_perf grp,
1162: hr_lookups hrl
1163: where pac.payroll_action_id = p_pact_rec.pact_id
1164: and hrl.lookup_code = pac.action_type