APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXP_LINE_ALL

Line 1768: FROM pn_rec_exp_line_all

1764: to_date,
1765: as_of_date,
1766: currency_code,
1767: org_id
1768: FROM pn_rec_exp_line_all
1769: WHERE expense_extract_code = p_extract_code;
1770:
1771: l_exist BOOLEAN := FALSE;
1772: l_same BOOLEAN := FALSE;

Line 2085: FROM pn_rec_exp_line_all hdr

2081: FOR UPDATE OF transfer_flag, expense_line_dtl_id NOWAIT;
2082:
2083: CURSOR is_reextract IS
2084: SELECT expense_line_id
2085: FROM pn_rec_exp_line_all hdr
2086: WHERE hdr.expense_extract_code = p_extract_code
2087: AND p_extract_code IS NOT NULL
2088: AND rownum < 2;
2089:

Line 2809: FROM pn_rec_exp_line_all hdr

2805:
2806: CURSOR get_exp_line_id IS
2807: SELECT expense_line_id,
2808: currency_code
2809: FROM pn_rec_exp_line_all hdr
2810: WHERE hdr.expense_extract_code = p_extract_code
2811: AND rownum < 2;
2812:
2813: CURSOR get_expcl_by_prop (p_propid pn_rec_exp_line.property_id%TYPE,

Line 3207: FROM pn_rec_exp_line_all

3203: IS
3204:
3205: CURSOR check_currency IS
3206: SELECT 1
3207: FROM pn_rec_exp_line_all
3208: WHERE expense_line_id = p_expense_line_id
3209: AND currency_code NOT IN
3210: (SELECT currency_code FROM pn_rec_expcl_all
3211: WHERE expense_class_id = p_expense_class_id);

Line 3298: pn_rec_exp_line_all lines

3294: FROM pn_rec_expcl_dtl_all summary,
3295: pn_rec_expcl_dtlln_all class_line,
3296: pn_rec_expcl_dtlacc_all class_line_dtl,
3297: pn_rec_expcl_all class,
3298: pn_rec_exp_line_all lines
3299: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id
3300: AND class_line.expense_class_dtl_id = summary.expense_class_dtl_id
3301: AND summary.expense_class_id = class.expense_class_id
3302: AND class.expense_class_id = p_expense_class_id

Line 3310: pn_rec_exp_line_all line_hdr,

3306: CURSOR get_prior_cls_dtl_id IS
3307: SELECT summary.expense_class_dtl_id
3308: FROM pn_rec_expcl_dtl_all summary,
3309: pn_rec_expcl_all class,
3310: pn_rec_exp_line_all line_hdr,
3311: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all
3312: WHERE expense_line_id = p_expense_line_id) ref_line_hdr
3313: WHERE summary.expense_class_id = class.expense_class_id
3314: AND summary.expense_line_id = line_hdr.expense_line_id

Line 3311: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all

3307: SELECT summary.expense_class_dtl_id
3308: FROM pn_rec_expcl_dtl_all summary,
3309: pn_rec_expcl_all class,
3310: pn_rec_exp_line_all line_hdr,
3311: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all
3312: WHERE expense_line_id = p_expense_line_id) ref_line_hdr
3313: WHERE summary.expense_class_id = class.expense_class_id
3314: AND summary.expense_line_id = line_hdr.expense_line_id
3315: AND class.expense_class_id = p_expense_class_id

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;