APPS.PAY_JP_SOE_PKG dependencies on PER_ALL_ASSIGNMENTS

Line 144: per_all_assignments asg

140: SELECT NVL(org.org_information4, 'N')
141: INTO l_use_advanced_retropay
142: FROM pay_assignment_actions paa,
143: hr_organization_information org,
144: per_all_assignments asg
145: WHERE paa.assignment_action_id = p_creator_id
146: AND paa.assignment_id = asg.assignment_id
147: AND org.organization_id = asg.business_group_id
148: AND org.org_information_context LIKE 'JP_BUSINESS_GROUP_INFO';

Line 478: from per_all_assignments_f paa

474: CURSOR csr_get_effective_date IS
475: select nvl( nvl( min(decode(greatest(least(p_effective_date,paa.effective_end_date), paa.effective_start_date),p_effective_date,p_effective_date)),
476: max(decode(greatest(paa.effective_end_date,p_effective_date),p_effective_date,paa.effective_end_date))),
477: min(decode(least(p_effective_date, paa.effective_start_date),p_effective_date, paa.effective_start_date)) ) EFFECTIVE_DATE
478: from per_all_assignments_f paa
479: where to_number(to_char(p_effective_date, 'YYYY'))
480: between to_number(to_char(paa.effective_start_date, 'YYYY'))
481: and to_number(to_char(paa.effective_end_date, 'YYYY'))
482: and paa.assignment_id = p_assignment_id;