APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 443: from per_all_assignments_f asg

439: effective_start_date
440: into l_business_group_id,
441: l_person_id,
442: l_effective_date
443: from per_all_assignments_f asg
444: where assignment_id = p_assignment_id
445: and rownum <= 1;
446: --
447: select per.party_id,

Line 906: from per_all_assignments_f

902: if l_rule_mode = 'Y' then
903: select distinct
904: business_group_id
905: into l_business_group_id
906: from per_all_assignments_f
907: where assignment_id = p_assignment_id;
908: --
909: l_rule_mode := pay_core_utils.get_upgrade_status(l_business_group_id, 'ENABLE_RR_SPARSE');
910: end if;

Line 1294: l_person_id per_all_assignments_f.person_id%TYPE;

1290: procedure upgrade_jp_pre_tax(p_assignment_id in number)
1291: is
1292: c_proc constant varchar2(61) := c_package || 'upgrade_jp_pre_tax';
1293: --
1294: l_person_id per_all_assignments_f.person_id%TYPE;
1295: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
1296: l_date_start per_periods_of_service.date_start%TYPE;
1297: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
1298: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

Line 1295: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

1291: is
1292: c_proc constant varchar2(61) := c_package || 'upgrade_jp_pre_tax';
1293: --
1294: l_person_id per_all_assignments_f.person_id%TYPE;
1295: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
1296: l_date_start per_periods_of_service.date_start%TYPE;
1297: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
1298: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1299: l_employment_category per_all_assignments.employment_category%TYPE;

Line 1346: from per_all_assignments_f asg,

1342: l_date_start,
1343: l_leaving_reason,
1344: l_actual_termination_date,
1345: l_employment_category
1346: from per_all_assignments_f asg,
1347: per_periods_of_service pds
1348: where asg.assignment_id = p_assignment_id
1349: and l_effective_date between asg.effective_start_date and asg.effective_end_date
1350: and pds.period_of_service_id = asg.period_of_service_id;