APPS.PAY_RI_AC_TAX_RULE dependencies on PER_ALL_ASSIGNMENTS_F

Line 942: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;

938: ln_citytax_rule_id pay_us_emp_city_tax_rules_f.EMP_city_TAX_RULE_ID%TYPE;
939: ln_cafedtax_inf_id PAY_CA_EMP_FED_TAX_INFO_F.EMP_FED_TAX_INF_ID%TYPE;
940: ln_caprovtax_inf_id PAY_CA_EMP_PROV_TAX_INFO_F.EMP_PROVINCE_TAX_INF_ID%TYPE;
941:
942: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
943: ln_batch_exists number;
944: lv_lookup_code varchar2(20);
945:
946: -- Added for datapump wrapper

Line 1033: from per_all_assignments_f paf,

1029:
1030: /* cursor to get the assignment_id */
1031: CURSOR csr_get_asg_id is
1032: select paf.assignment_id
1033: from per_all_assignments_f paf,
1034: per_all_people_f ppf
1035: where ppf.full_name = p_employee
1036: and ppf.person_id = paf.person_id
1037: and ppf.business_group_id = p_business_group