APPS.PAY_US_EMP_DT_TAX_VAL dependencies on PER_ADDRESSES

Line 77: per_addresses pa,

73: SELECT pus1.state_code,
74: pus.state_code
75: FROM pay_us_states pus,
76: pay_us_states pus1,
77: per_addresses pa,
78: per_assignments_f paf
79: WHERE paf.assignment_id = p_assignment_id
80: AND p_session_date BETWEEN paf.effective_start_date
81: AND paf.effective_end_date

Line 99: per_addresses pa,

95: FROM pay_us_states pus,
96: pay_us_states pus1,
97: pay_us_counties puc,
98: pay_us_counties puc1,
99: per_addresses pa,
100: per_assignments_f paf
101: WHERE paf.assignment_id = p_assignment_id
102: AND p_session_date BETWEEN paf.effective_start_date
103: AND paf.effective_end_date

Line 130: per_addresses pa,

126: pay_us_counties puc,
127: pay_us_counties puc1,
128: pay_us_city_names pucy,
129: pay_us_city_names pucy1,
130: per_addresses pa,
131: per_assignments_f paf
132: WHERE paf.assignment_id = p_assignment_id
133: AND p_session_date BETWEEN paf.effective_start_date
134: AND paf.effective_end_date

Line 1041: from PER_ADDRESSES pa,

1037: /* modified cursors to check _both_ mailing and taxation address, instead of one or the other */
1038:
1039: CURSOR csr_check_state is
1040: select 1
1041: from PER_ADDRESSES pa,
1042: PER_ASSIGNMENTS_F paf
1043: where paf.assignment_id = p_assignment_id
1044: and pa.person_id = paf.person_id
1045: and exists (select null

Line 1055: from PER_ADDRESSES pa,

1051: resident address of the assignment. */
1052:
1053: CURSOR csr_check_county is
1054: select 1
1055: from PER_ADDRESSES pa,
1056: PER_ASSIGNMENTS_F paf
1057: where paf.assignment_id = p_assignment_id
1058: and pa.person_id = paf.person_id
1059: and exists (select null

Line 1076: from PER_ADDRESSES pa,

1072: resident address of the assignment. */
1073:
1074: CURSOR csr_check_city is
1075: select 1
1076: from PER_ADDRESSES pa,
1077: PER_ASSIGNMENTS_F paf
1078: where paf.assignment_id = p_assignment_id
1079: and pa.person_id = paf.person_id
1080: and exists (select null

Line 1634: PER_ADDRESSES pa,

1630: puci.city_name
1631: from PAY_US_CITY_NAMES puci,
1632: PAY_US_COUNTIES puc,
1633: PAY_US_STATES pus,
1634: PER_ADDRESSES pa,
1635: PER_ASSIGNMENTS_F paf
1636: where paf.assignment_id = p_assignment_id
1637: and p_session_date between paf.effective_start_date and
1638: paf.effective_end_date

Line 2283: PER_ADDRESSES pa,

2279: puci.city_name
2280: from PAY_US_CITY_NAMES puci,
2281: PAY_US_COUNTIES puc,
2282: PAY_US_STATES pus,
2283: PER_ADDRESSES pa,
2284: PER_ASSIGNMENTS_F paf
2285: where paf.assignment_id = p_assignment_id
2286: and p_session_date between paf.effective_start_date and
2287: paf.effective_end_date