APPS.PAY_JP_DEF_SS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 248: pay_assignment_actions paa,

244: select submission_period_status,
245: submission_start_date,
246: submission_end_date
247: from pay_jp_def_pact_v pact,
248: pay_assignment_actions paa,
249: pay_jp_def_assact_v assact
250: where assact.action_information_id = p_action_information_id
251: and paa.assignment_action_id = assact.assignment_action_id
252: and pact.payroll_action_id = paa.payroll_action_id;

Line 2857: pay_assignment_actions paa

2853: cursor csr_assact is
2854: select aif.action_information_id,
2855: aif.object_version_number
2856: from pay_jp_def_assact_v aif,
2857: pay_assignment_actions paa
2858: where paa.payroll_action_id = l_payroll_action_id
2859: and paa.action_status = 'C'
2860: and aif.assignment_action_id = paa.assignment_action_id
2861: and transaction_status = 'F';

Line 3181: pay_assignment_actions paa

3177: asg.assignment_number
3178: from per_all_people_f per,
3179: per_all_assignments_f asg,
3180: pay_jp_def_assact_v assact,
3181: pay_assignment_actions paa
3182: where paa.payroll_action_id = l_payroll_action_id
3183: and paa.action_status = 'C'
3184: and assact.assignment_action_id = paa.assignment_action_id
3185: and assact.transaction_status = 'A'

Line 4058: pay_assignment_actions paa

4054: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);
4055: cursor csr_assact is
4056: select paa.assignment_action_id
4057: from pay_jp_def_assact_v aif,
4058: pay_assignment_actions paa
4059: where paa.payroll_action_id = l_payroll_action_id
4060: and aif.assignment_action_id(+) = paa.assignment_action_id
4061: and nvl(aif.transaction_status, 'U') not in ('F', 'A');
4062: begin