APPS.PAY_US_EMP_TAX_RULES_PKG dependencies on PER_ASSIGNMENTS_F

Line 905: from PER_ASSIGNMENTS_F paf,

901: pa.town_or_city,
902: pa.town_or_city,
903: pa.region_1,
904: pa.postal_code
905: from PER_ASSIGNMENTS_F paf,
906: PER_ADDRESSES pa,
907: PAY_STATE_RULES psr
908: where paf.assignment_id = P_assignment_id
909: and P_session_date between paf.effective_start_date and

Line 928: from PER_ASSIGNMENTS_F paf,

924: hl.postal_code,
925: psr.jurisdiction_code,
926: hl.town_or_city,
927: hl.town_or_city
928: from PER_ASSIGNMENTS_F paf,
929: HR_LOCATIONS hl,
930: PAY_STATE_RULES psr
931: where paf.assignment_id = P_assignment_id
932: and P_session_date between paf.effective_start_date and

Line 1131: from per_assignments_f paf,

1127: --
1128: CURSOR csr_fed_or_def is -- Bug 3354046: Index has been forced on table pay_state_rules to remove FTS and
1129: select /*+ index (sr PAY_STATE_RULES_PK) -- MJC.
1130: ordered */hoi.org_information12
1131: from per_assignments_f paf,
1132: hr_soft_coding_keyflex hsck,
1133: hr_organization_information hoi ,
1134: pay_state_rules sr
1135: where paf.assignment_id = p_assignment_id

Line 1707: from PER_ASSIGNMENTS_F

1703:
1704: -- Get Effective_start_Date of assignment
1705: CURSOR csr_get_eff_Date is
1706: select effective_start_date
1707: from PER_ASSIGNMENTS_F
1708: where assignment_id = P_assignment_id
1709: and P_session_date between effective_start_date and
1710: effective_end_date;
1711: --

Line 1926: from PER_ASSIGNMENTS_F

1922:
1923: -- Get Effective_start_Date of assignment
1924: CURSOR csr_get_eff_Date is
1925: select effective_start_date
1926: from PER_ASSIGNMENTS_F
1927: where assignment_id = P_assignment_id
1928: and P_session_date between effective_start_date and
1929: effective_end_date;
1930: --

Line 2324: FROM per_assignments_f

2320: -- defaulted.
2321: --
2322: CURSOR csr_qualify_info(per_id NUMBER) IS
2323: SELECT assignment_id
2324: FROM per_assignments_f
2325: WHERE person_id = per_id
2326: AND assignment_type = 'E'
2327: AND location_id IS NOT NULL
2328: AND payroll_id IS NOT NULL

Line 2339: FROM per_assignments_f paf,

2335: --a form other than the assignment form.
2336: --
2337: CURSOR csr_person_info(per_id NUMBER) IS
2338: SELECT paf.assignment_id
2339: FROM per_assignments_f paf,
2340: per_people_f ppf,
2341: per_addresses pa
2342: WHERE paf.person_id = ppf.person_id
2343: AND paf.assignment_type = 'E'

Line 2358: from PER_ASSIGNMENTS_F paf,

2354: psr.state_code,
2355: hl.region_1,
2356: hl.postal_code,
2357: hl.town_or_city
2358: from PER_ASSIGNMENTS_F paf,
2359: HR_LOCATIONS hl,
2360: PAY_STATE_RULES psr
2361: where paf.assignment_id = P_assignment_id
2362: and P_date between paf.effective_start_date and