APPS.PAY_CTY_BUS dependencies on PER_ASSIGNMENTS_F

Line 57: l_assignment_id per_assignments_f.assignment_id%TYPE;

53: --
54: l_proc varchar2(72) := g_package||'chk_assignment_id';
55: l_tmp varchar2(2);
56: l_api_updating boolean;
57: l_assignment_id per_assignments_f.assignment_id%TYPE;
58: l_business_group_id per_assignments_f.business_group_id%TYPE;
59: --
60: --
61: cursor csr_business_grp is

Line 58: l_business_group_id per_assignments_f.business_group_id%TYPE;

54: l_proc varchar2(72) := g_package||'chk_assignment_id';
55: l_tmp varchar2(2);
56: l_api_updating boolean;
57: l_assignment_id per_assignments_f.assignment_id%TYPE;
58: l_business_group_id per_assignments_f.business_group_id%TYPE;
59: --
60: --
61: cursor csr_business_grp is
62: select business_group_id

Line 63: from per_assignments_f

59: --
60: --
61: cursor csr_business_grp is
62: select business_group_id
63: from per_assignments_f
64: where assignment_id = p_assignment_id
65: and p_effective_date between effective_start_date and
66: effective_end_date;
67: --

Line 1103: p_assignment_id in per_assignments_f.assignment_id%TYPE,

1099: -- Internal Row Handler Use Only.
1100: --
1101: procedure chk_delete
1102: (p_effective_date in date,
1103: p_assignment_id in per_assignments_f.assignment_id%TYPE,
1104: p_city_code in pay_us_emp_city_tax_rules_f.city_code%TYPE,
1105: p_county_code in pay_us_emp_city_tax_rules_f.county_code%TYPE,
1106: p_state_code in pay_us_emp_city_tax_rules_f.state_code%TYPE,
1107: p_delete_mode in varchar2,

Line 1123: per_assignments_f paf -- Bug 3419786

1119: is
1120: select prr.run_result_id from
1121: pay_run_results prr,
1122: pay_assignment_actions paa,
1123: per_assignments_f paf -- Bug 3419786
1124: where paf.assignment_id = p_assignment_id -- Bug 3419786
1125: and paf.assignment_id = paa.assignment_id
1126: and prr.assignment_action_id = paa.assignment_action_id
1127: and prr.jurisdiction_code =

Line 1148: from per_assignments_f paf,

1144: --
1145: cursor chk_city_work(p_csr_tmp_date in date)
1146: is
1147: select hrl.location_id
1148: from per_assignments_f paf,
1149: hr_locations hrl
1150: where paf.assignment_id = p_assignment_id
1151: and hrl.location_id = paf.location_id
1152: and paf.effective_end_date > p_csr_tmp_date

Line 1175: from per_assignments_f paf,

1171: --
1172: cursor chk_city_residence(p_csr_tmp_date in date)
1173: is
1174: select 1
1175: from per_assignments_f paf,
1176: per_addresses pa
1177: where paf.assignment_id = p_assignment_id
1178: and pa.person_id = paf.person_id
1179: and pa.primary_flag = 'Y'