APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_SPACE_ASSIGN_CUST

Line 973: FROM pn_space_assign_cust_all cust

969: fin_oblig_end_date,
970: lease_id,
971: recovery_type_code,
972: recovery_space_std_code
973: FROM pn_space_assign_cust_all cust
974: WHERE cust.location_id = p_location_id
975: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)
976: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date);
977:

Line 2249: p_location_id pn_space_assign_cust.location_id%TYPE,

2245: p_share_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2246: p_master_data_id OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2247: p_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2248: p_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
2249: p_location_id pn_space_assign_cust.location_id%TYPE,
2250: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2251: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2252: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2253: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,

Line 2250: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,

2246: p_master_data_id OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2247: p_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2248: p_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
2249: p_location_id pn_space_assign_cust.location_id%TYPE,
2250: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2251: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2252: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2253: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2254: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,

Line 2251: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,

2247: p_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2248: p_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
2249: p_location_id pn_space_assign_cust.location_id%TYPE,
2250: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2251: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2252: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2253: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2254: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2255: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,

Line 3257: p_rec_spc_std_code pn_space_assign_cust.recovery_space_std_code%TYPE,

3253:
3254: CURSOR get_cust_assignment_info(
3255: p_location_id pn_locations.location_id%TYPE,
3256: p_property_id pn_locations.property_id%TYPE,
3257: p_rec_spc_std_code pn_space_assign_cust.recovery_space_std_code%TYPE,
3258: p_rec_type_code pn_space_assign_cust.recovery_type_code%TYPE) IS
3259: SELECT cust.cust_space_assign_id,
3260: cust.cust_account_id,
3261: cust.lease_id,

Line 3258: p_rec_type_code pn_space_assign_cust.recovery_type_code%TYPE) IS

3254: CURSOR get_cust_assignment_info(
3255: p_location_id pn_locations.location_id%TYPE,
3256: p_property_id pn_locations.property_id%TYPE,
3257: p_rec_spc_std_code pn_space_assign_cust.recovery_space_std_code%TYPE,
3258: p_rec_type_code pn_space_assign_cust.recovery_type_code%TYPE) IS
3259: SELECT cust.cust_space_assign_id,
3260: cust.cust_account_id,
3261: cust.lease_id,
3262: cust.location_id,

Line 3265: FROM pn_space_assign_cust_all cust

3261: cust.lease_id,
3262: cust.location_id,
3263: cust.recovery_space_std_code,
3264: cust.recovery_type_code
3265: FROM pn_space_assign_cust_all cust
3266: WHERE cust.location_id IN
3267: (SELECT location_id FROM pn_locations_all locn
3268: WHERE locn.active_start_date < fnd_date.canonical_to_date(p_to_date)
3269: AND locn.active_end_date > fnd_date.canonical_to_date(p_from_date))