eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 912: from per_all_assignments_f

908: if l_rule_mode = 'Y' then
909: select distinct
910: business_group_id
911: into l_business_group_id
912: from per_all_assignments_f
913: where assignment_id = p_assignment_id;
914: --
915: l_rule_mode := pay_core_utils.get_upgrade_status(l_business_group_id, 'ENABLE_RR_SPARSE');
916: end if;

Line 1300: l_person_id per_all_assignments_f.person_id%TYPE;

1296: procedure upgrade_jp_pre_tax(p_assignment_id in number)
1297: is
1298: c_proc constant varchar2(61) := c_package || 'upgrade_jp_pre_tax';
1299: --
1300: l_person_id per_all_assignments_f.person_id%TYPE;
1301: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
1302: l_date_start per_periods_of_service.date_start%TYPE;
1303: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
1304: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

Line 1301: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

1297: is
1298: c_proc constant varchar2(61) := c_package || 'upgrade_jp_pre_tax';
1299: --
1300: l_person_id per_all_assignments_f.person_id%TYPE;
1301: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
1302: l_date_start per_periods_of_service.date_start%TYPE;
1303: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
1304: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1305: l_employment_category per_all_assignments.employment_category%TYPE;

Line 1352: from per_all_assignments_f asg,

1348: l_date_start,
1349: l_leaving_reason,
1350: l_actual_termination_date,
1351: l_employment_category
1352: from per_all_assignments_f asg,
1353: per_periods_of_service pds
1354: where asg.assignment_id = p_assignment_id
1355: and l_effective_date between asg.effective_start_date and asg.effective_end_date
1356: and pds.period_of_service_id = asg.period_of_service_id;