APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXP_LINE_DTL_ALL

Line 3245: FROM pn_rec_exp_line_dtl_all lines_dtl

3241: lines_dtl.property_id,
3242: lines_dtl.expense_line_dtl_id,
3243: lines_dtl.expense_line_id,
3244: lines_dtl.expense_line_indicator
3245: FROM pn_rec_exp_line_dtl_all lines_dtl
3246: WHERE (lines_dtl.expense_line_id = p_expense_line_id OR
3247: lines_dtl.parent_expense_line_id IN
3248: (SELECT expense_line_dtl_id
3249: FROM pn_rec_exp_line_dtl_all

Line 3249: FROM pn_rec_exp_line_dtl_all

3245: FROM pn_rec_exp_line_dtl_all lines_dtl
3246: WHERE (lines_dtl.expense_line_id = p_expense_line_id OR
3247: lines_dtl.parent_expense_line_id IN
3248: (SELECT expense_line_dtl_id
3249: FROM pn_rec_exp_line_dtl_all
3250: WHERE expense_line_id = p_expense_line_id))
3251: AND lines_dtl.expense_type_code = p_expense_type_code
3252: AND lines_dtl.recoverable_flag = 'Y';
3253:

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

4002: IF p_extract_code IS NOT NULL THEN
4003:
4004: l_sqltail := ' expense_line_dtl_id IN ' ||
4005: '(SELECT dtl.expense_line_dtl_id ' ||
4006: ' FROM pn_rec_exp_line_all hdr, pn_rec_exp_line_dtl_all dtl ' ||
4007: ' WHERE hdr.expense_line_id = dtl.expense_line_id ' ||
4008: ' AND hdr.expense_extract_code = :l_extract_code)';
4009:
4010: END IF;