APPS.PAY_CNT_BUS dependencies on PER_ASSIGNMENTS_F

Line 18: -- - an entry in PER_ASSIGNMENTS_F

14: --
15: --
16: -- Description:
17: -- - Determines if the current assignment has:
18: -- - an entry in PER_ASSIGNMENTS_F
19: -- - a business group id that match the business group id of the
20: -- - tax record.
21: -- - met defaulting criteria by checking to see if the current
22: -- - assignment exists in the pay_us_emp_fed_tax_rules_f table

Line 62: l_assignment_id per_assignments_f.assignment_id%TYPE;

58: --
59: l_proc varchar2(72) := g_package||'chk_assignment_id';
60: l_tmp varchar2(2);
61: l_api_updating boolean;
62: l_assignment_id per_assignments_f.assignment_id%TYPE;
63: l_business_group_id per_assignments_f.business_group_id%TYPE;
64: --
65: --
66: cursor csr_business_grp is

Line 63: l_business_group_id per_assignments_f.business_group_id%TYPE;

59: l_proc varchar2(72) := g_package||'chk_assignment_id';
60: l_tmp varchar2(2);
61: l_api_updating boolean;
62: l_assignment_id per_assignments_f.assignment_id%TYPE;
63: l_business_group_id per_assignments_f.business_group_id%TYPE;
64: --
65: --
66: cursor csr_business_grp is
67: select business_group_id

Line 68: from per_assignments_f

64: --
65: --
66: cursor csr_business_grp is
67: select business_group_id
68: from per_assignments_f
69: where assignment_id = p_assignment_id
70: and p_effective_date between effective_start_date and
71: effective_end_date;
72: --

Line 1117: p_assignment_id in per_assignments_f.assignment_id%TYPE,

1113: -- Internal Row Handler Use Only.
1114: --
1115: procedure chk_delete
1116: (p_effective_date in date,
1117: p_assignment_id in per_assignments_f.assignment_id%TYPE,
1118: p_state_code in pay_us_emp_county_tax_rules_f.state_code%TYPE,
1119: p_county_code in pay_us_emp_county_tax_rules_f.county_code%TYPE,
1120: p_delete_mode in varchar2,
1121: p_delete_routine in varchar2 default null

Line 1137: per_assignments_f paf --Bug 3419781

1133: is
1134: select prr.run_result_id from
1135: pay_run_results prr,
1136: pay_assignment_actions paa,
1137: per_assignments_f paf --Bug 3419781
1138: where paf.assignment_id = p_assignment_id --Bug 3419781
1139: and paf.assignment_id = paa.assignment_id
1140: and prr.assignment_action_id = paa.assignment_action_id
1141: and substr(prr.jurisdiction_code,1,6)=p_state_code||'-'||p_county_code

Line 1161: from per_assignments_f paf,

1157: --
1158: cursor chk_county_work(p_csr_tmp_date in date)
1159: is
1160: select hrl.location_id
1161: from per_assignments_f paf,
1162: hr_locations hrl
1163: where paf.assignment_id = p_assignment_id
1164: and hrl.location_id = paf.location_id
1165: and paf.effective_end_date > p_csr_tmp_date

Line 1183: from per_assignments_f paf,

1179: --
1180: cursor chk_county_residence(p_csr_tmp_date in date)
1181: is
1182: select 1
1183: from per_assignments_f paf,
1184: per_addresses pa
1185: where paf.assignment_id = p_assignment_id
1186: and pa.person_id = paf.person_id
1187: and pa.primary_flag = 'Y'