APPS.PAY_JP_DEF_SS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 241: pay_assignment_actions paa,

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
245: and pact.payroll_action_id = paa.payroll_action_id;

Line 2233: pay_assignment_actions paa

2229: cursor csr_assact is
2230: select aif.action_information_id,
2231: aif.object_version_number
2232: from pay_jp_def_assact_v aif,
2233: pay_assignment_actions paa
2234: where paa.payroll_action_id = l_payroll_action_id
2235: and paa.action_status = 'C'
2236: and aif.assignment_action_id = paa.assignment_action_id
2237: and transaction_status = 'F';

Line 2475: pay_assignment_actions paa

2471: asg.assignment_number
2472: from per_all_people_f per,
2473: per_all_assignments_f asg,
2474: pay_jp_def_assact_v assact,
2475: pay_assignment_actions paa
2476: where paa.payroll_action_id = l_payroll_action_id
2477: and paa.action_status = 'C'
2478: and assact.assignment_action_id = paa.assignment_action_id
2479: and assact.transaction_status = 'A'

Line 3143: pay_assignment_actions paa

3139: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);
3140: cursor csr_assact is
3141: select paa.assignment_action_id
3142: from pay_jp_def_assact_v aif,
3143: pay_assignment_actions paa
3144: where paa.payroll_action_id = l_payroll_action_id
3145: and aif.assignment_action_id(+) = paa.assignment_action_id
3146: and nvl(aif.transaction_status, 'U') not in ('F', 'A');
3147: begin