DBA Data[Home] [Help]

APPS.FTE_LOCATION_PARAMETERS_PKG dependencies on FTE_PRC_PARAMETERS

Line 1201: fte_prc_parameters prc_cbasis,

1197: l_charge_basis,
1198: l_charge_basis_uom,
1199: x_fac_info_rows(k).fac_currency
1200: FROM fte_location_parameters fl,
1201: fte_prc_parameters prc_cbasis,
1202: fte_prc_parameters prc_cbasis_uom,
1203: fte_prc_parameters prc_currency,
1204: fte_prc_parameters prc_rc_id
1205: WHERE fl.location_id = x_fac_info_rows(k).location_id

Line 1202: fte_prc_parameters prc_cbasis_uom,

1198: l_charge_basis_uom,
1199: x_fac_info_rows(k).fac_currency
1200: FROM fte_location_parameters fl,
1201: fte_prc_parameters prc_cbasis,
1202: fte_prc_parameters prc_cbasis_uom,
1203: fte_prc_parameters prc_currency,
1204: fte_prc_parameters prc_rc_id
1205: WHERE fl.location_id = x_fac_info_rows(k).location_id
1206: AND prc_cbasis.list_header_id(+) = fl.modifier_list

Line 1203: fte_prc_parameters prc_currency,

1199: x_fac_info_rows(k).fac_currency
1200: FROM fte_location_parameters fl,
1201: fte_prc_parameters prc_cbasis,
1202: fte_prc_parameters prc_cbasis_uom,
1203: fte_prc_parameters prc_currency,
1204: fte_prc_parameters prc_rc_id
1205: WHERE fl.location_id = x_fac_info_rows(k).location_id
1206: AND prc_cbasis.list_header_id(+) = fl.modifier_list
1207: AND prc_cbasis_uom.list_header_id(+)= fl.modifier_list

Line 1204: fte_prc_parameters prc_rc_id

1200: FROM fte_location_parameters fl,
1201: fte_prc_parameters prc_cbasis,
1202: fte_prc_parameters prc_cbasis_uom,
1203: fte_prc_parameters prc_currency,
1204: fte_prc_parameters prc_rc_id
1205: WHERE fl.location_id = x_fac_info_rows(k).location_id
1206: AND prc_cbasis.list_header_id(+) = fl.modifier_list
1207: AND prc_cbasis_uom.list_header_id(+)= fl.modifier_list
1208: AND prc_currency.list_header_id(+) = fl.modifier_list