APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXP_LINE_DTL_ALL

Line 3233: FROM pn_rec_exp_line_dtl_all lines_dtl

3229: lines_dtl.property_id,
3230: lines_dtl.expense_line_dtl_id,
3231: lines_dtl.expense_line_id,
3232: lines_dtl.expense_line_indicator
3233: FROM pn_rec_exp_line_dtl_all lines_dtl
3234: WHERE (lines_dtl.expense_line_id = p_expense_line_id OR
3235: lines_dtl.parent_expense_line_id IN
3236: (SELECT expense_line_dtl_id
3237: FROM pn_rec_exp_line_dtl_all

Line 3237: FROM pn_rec_exp_line_dtl_all

3233: FROM pn_rec_exp_line_dtl_all lines_dtl
3234: WHERE (lines_dtl.expense_line_id = p_expense_line_id OR
3235: lines_dtl.parent_expense_line_id IN
3236: (SELECT expense_line_dtl_id
3237: FROM pn_rec_exp_line_dtl_all
3238: WHERE expense_line_id = p_expense_line_id))
3239: AND lines_dtl.expense_type_code = p_expense_type_code
3240: AND lines_dtl.recoverable_flag = 'Y';
3241:

Line 3994: ' FROM pn_rec_exp_line_all hdr, pn_rec_exp_line_dtl_all dtl ' ||

3990: IF p_extract_code IS NOT NULL THEN
3991:
3992: l_sqltail := ' expense_line_dtl_id IN ' ||
3993: '(SELECT dtl.expense_line_dtl_id ' ||
3994: ' FROM pn_rec_exp_line_all hdr, pn_rec_exp_line_dtl_all dtl ' ||
3995: ' WHERE hdr.expense_line_id = dtl.expense_line_id ' ||
3996: ' AND hdr.expense_extract_code = :l_extract_code)';
3997:
3998: END IF;