APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_PROPERTIES

Line 1690: SELECT 'TRUE' FROM pn_properties_all WHERE property_id = p_property_id;

1686: CURSOR loc_check IS
1687: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id;
1688:
1689: CURSOR prop_check IS
1690: SELECT 'TRUE' FROM pn_properties_all WHERE property_id = p_property_id;
1691:
1692: /* Commented and modified for Bug 6461211
1693: CURSOR prop_loc_combo_check IS
1694: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id AND property_id = p_property_id; */

Line 3775: p_property_code IN pn_properties.property_code%TYPE,

3771: PROCEDURE extract_line_expense_area(
3772: errbuf OUT NOCOPY VARCHAR2,
3773: retcode OUT NOCOPY VARCHAR2,
3774: p_location_code IN pn_locations.location_code%TYPE,
3775: p_property_code IN pn_properties.property_code%TYPE,
3776: p_as_of_date IN VARCHAR2,
3777: p_from_date IN VARCHAR2,
3778: p_to_date IN VARCHAR2,
3779: p_currency_code IN pn_rec_exp_line.currency_code%TYPE,

Line 3805: FROM pn_properties

3801: AND rownum = 1;
3802:
3803: CURSOR derive_prop_id_from_prop_code IS
3804: SELECT property_id
3805: FROM pn_properties
3806: WHERE property_code = p_property_code;
3807:
3808: CURSOR get_functional_currency_code IS
3809: SELECT currency_code

Line 3948: p_property_code IN pn_properties.property_code%TYPE,

3944: errbuf OUT NOCOPY VARCHAR2,
3945: retcode OUT NOCOPY VARCHAR2,
3946: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,
3947: p_location_code IN pn_locations.location_code%TYPE,
3948: p_property_code IN pn_properties.property_code%TYPE,
3949: p_from_date IN VARCHAR2,
3950: p_to_date IN VARCHAR2,
3951: p_transfer_flag IN pn_rec_exp_itf.transfer_flag%TYPE,
3952: p_delete_all_flag IN VARCHAR2)

Line 3962: FROM pn_properties

3958: WHERE location_code = p_location_code;
3959:
3960: CURSOR derive_prop_id_from_prop_code IS
3961: SELECT property_id
3962: FROM pn_properties
3963: WHERE property_code = p_property_code;
3964:
3965: l_loc_id pn_locations.location_id%TYPE;
3966: l_prop_id pn_locations.property_id%TYPE;