APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_PROPERTIES

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

1674: CURSOR loc_check IS
1675: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id;
1676:
1677: CURSOR prop_check IS
1678: SELECT 'TRUE' FROM pn_properties_all WHERE property_id = p_property_id;
1679:
1680: /* Commented and modified for Bug 6461211
1681: CURSOR prop_loc_combo_check IS
1682: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id AND property_id = p_property_id; */

Line 3763: p_property_code IN pn_properties.property_code%TYPE,

3759: PROCEDURE extract_line_expense_area(
3760: errbuf OUT NOCOPY VARCHAR2,
3761: retcode OUT NOCOPY VARCHAR2,
3762: p_location_code IN pn_locations.location_code%TYPE,
3763: p_property_code IN pn_properties.property_code%TYPE,
3764: p_as_of_date IN VARCHAR2,
3765: p_from_date IN VARCHAR2,
3766: p_to_date IN VARCHAR2,
3767: p_currency_code IN pn_rec_exp_line.currency_code%TYPE,

Line 3793: FROM pn_properties

3789: AND rownum = 1;
3790:
3791: CURSOR derive_prop_id_from_prop_code IS
3792: SELECT property_id
3793: FROM pn_properties
3794: WHERE property_code = p_property_code;
3795:
3796: CURSOR get_functional_currency_code IS
3797: SELECT currency_code

Line 3936: p_property_code IN pn_properties.property_code%TYPE,

3932: errbuf OUT NOCOPY VARCHAR2,
3933: retcode OUT NOCOPY VARCHAR2,
3934: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,
3935: p_location_code IN pn_locations.location_code%TYPE,
3936: p_property_code IN pn_properties.property_code%TYPE,
3937: p_from_date IN VARCHAR2,
3938: p_to_date IN VARCHAR2,
3939: p_transfer_flag IN pn_rec_exp_itf.transfer_flag%TYPE,
3940: p_delete_all_flag IN VARCHAR2)

Line 3950: FROM pn_properties

3946: WHERE location_code = p_location_code;
3947:
3948: CURSOR derive_prop_id_from_prop_code IS
3949: SELECT property_id
3950: FROM pn_properties
3951: WHERE property_code = p_property_code;
3952:
3953: l_loc_id pn_locations.location_id%TYPE;
3954: l_prop_id pn_locations.property_id%TYPE;