APPS.PAY_DK_TCR dependencies on PER_ADDRESSES_V

Line 29: l_style per_addresses_v.style%type;

25: l_tax_card_type VARCHAR2(3);
26: l_sex VARCHAR2(1);
27: l_bg_id per_all_assignments_f.business_group_id%type;
28: l_le_id VARCHAR2(60);
29: l_style per_addresses_v.style%type;
30: l_flag NUMBER:=0;
31: l_effective_start_date DATE;
32: l_effective_end_date DATE;
33: l_input_value_id pay_input_values_f.input_value_id%type;

Line 112: FROM per_addresses_v

108:
109: /* Get the territory */
110: CURSOR csr_get_territory(pid per_all_people_f.person_id%type) IS
111: SELECT *
112: FROM per_addresses_v
113: WHERE person_id =pid
114: and primary_flag='Y'
115: and business_group_id=p_business_group_id;
116: