DBA Data[Home] [Help]

APPS.HRASSACT dependencies on HR_LOOKUPS

Line 659: action_name hr_lookups.meaning%type,

655: payroll_id per_all_assignments_f.payroll_id%type);
656: --
657: type pact_details is record
658: (pact_id pay_payroll_actions.payroll_action_id%type,
659: action_name hr_lookups.meaning%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.

Line 1162: hr_lookups hrl

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
1165: and hrl.lookup_type = 'ACTION_TYPE'
1166: and grp.business_group_id = pac.business_group_id