APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXP_LINE_ALL

Line 1756: FROM pn_rec_exp_line_all

1752: to_date,
1753: as_of_date,
1754: currency_code,
1755: org_id
1756: FROM pn_rec_exp_line_all
1757: WHERE expense_extract_code = p_extract_code;
1758:
1759: l_exist BOOLEAN := FALSE;
1760: l_same BOOLEAN := FALSE;

Line 2073: FROM pn_rec_exp_line_all hdr

2069: FOR UPDATE OF transfer_flag, expense_line_dtl_id NOWAIT;
2070:
2071: CURSOR is_reextract IS
2072: SELECT expense_line_id
2073: FROM pn_rec_exp_line_all hdr
2074: WHERE hdr.expense_extract_code = p_extract_code
2075: AND p_extract_code IS NOT NULL
2076: AND rownum < 2;
2077:

Line 2797: FROM pn_rec_exp_line_all hdr

2793:
2794: CURSOR get_exp_line_id IS
2795: SELECT expense_line_id,
2796: currency_code
2797: FROM pn_rec_exp_line_all hdr
2798: WHERE hdr.expense_extract_code = p_extract_code
2799: AND rownum < 2;
2800:
2801: CURSOR get_expcl_by_prop (p_propid pn_rec_exp_line.property_id%TYPE,

Line 3195: FROM pn_rec_exp_line_all

3191: IS
3192:
3193: CURSOR check_currency IS
3194: SELECT 1
3195: FROM pn_rec_exp_line_all
3196: WHERE expense_line_id = p_expense_line_id
3197: AND currency_code NOT IN
3198: (SELECT currency_code FROM pn_rec_expcl_all
3199: WHERE expense_class_id = p_expense_class_id);

Line 3286: pn_rec_exp_line_all lines

3282: FROM pn_rec_expcl_dtl_all summary,
3283: pn_rec_expcl_dtlln_all class_line,
3284: pn_rec_expcl_dtlacc_all class_line_dtl,
3285: pn_rec_expcl_all class,
3286: pn_rec_exp_line_all lines
3287: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id
3288: AND class_line.expense_class_dtl_id = summary.expense_class_dtl_id
3289: AND summary.expense_class_id = class.expense_class_id
3290: AND class.expense_class_id = p_expense_class_id

Line 3298: pn_rec_exp_line_all line_hdr,

3294: CURSOR get_prior_cls_dtl_id IS
3295: SELECT summary.expense_class_dtl_id
3296: FROM pn_rec_expcl_dtl_all summary,
3297: pn_rec_expcl_all class,
3298: pn_rec_exp_line_all line_hdr,
3299: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all
3300: WHERE expense_line_id = p_expense_line_id) ref_line_hdr
3301: WHERE summary.expense_class_id = class.expense_class_id
3302: AND summary.expense_line_id = line_hdr.expense_line_id

Line 3299: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all

3295: SELECT summary.expense_class_dtl_id
3296: FROM pn_rec_expcl_dtl_all summary,
3297: pn_rec_expcl_all class,
3298: pn_rec_exp_line_all line_hdr,
3299: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all
3300: WHERE expense_line_id = p_expense_line_id) ref_line_hdr
3301: WHERE summary.expense_class_id = class.expense_class_id
3302: AND summary.expense_line_id = line_hdr.expense_line_id
3303: AND class.expense_class_id = p_expense_class_id

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;