APPS.PAY_RI_AC_TAX_RULE dependencies on PER_ALL_ASSIGNMENTS_F

Line 936: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;

932: ln_citytax_rule_id pay_us_emp_city_tax_rules_f.EMP_city_TAX_RULE_ID%TYPE;
933: ln_cafedtax_inf_id PAY_CA_EMP_FED_TAX_INFO_F.EMP_FED_TAX_INF_ID%TYPE;
934: ln_caprovtax_inf_id PAY_CA_EMP_PROV_TAX_INFO_F.EMP_PROVINCE_TAX_INF_ID%TYPE;
935:
936: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
937: ln_batch_exists number;
938: lv_lookup_code varchar2(20);
939:
940: -- Added for datapump wrapper

Line 1027: from per_all_assignments_f paf,

1023:
1024: /* cursor to get the assignment_id */
1025: CURSOR csr_get_asg_id is
1026: select paf.assignment_id
1027: from per_all_assignments_f paf,
1028: per_all_people_f ppf
1029: where ppf.full_name = p_employee
1030: and ppf.person_id = paf.person_id
1031: and ppf.business_group_id = p_business_group