DBA Data[Home] [Help]

APPS.PAY_JP_DEF_SS dependencies on PAY_JP_DEF_PACT_V

Line 240: from pay_jp_def_pact_v pact,

236: cursor csr_pact is
237: select submission_period_status,
238: submission_start_date,
239: submission_end_date
240: from pay_jp_def_pact_v pact,
241: pay_assignment_actions paa,
242: pay_jp_def_assact_v assact
243: where assact.action_information_id = p_action_information_id
244: and paa.assignment_action_id = assact.assignment_action_id

Line 2498: from pay_jp_def_pact_v

2494: retcode := '0';
2495: --
2496: select effective_date
2497: into l_effective_date
2498: from pay_jp_def_pact_v
2499: where payroll_action_id = l_payroll_action_id;
2500: --
2501: insert_session(l_effective_date);
2502: commit;