[Home] [Help]
52: where aps.customer_id = hzca.cust_account_id
53: and aps.class IN ('INV', 'DM', 'CB')
54: and aps.due_date between g_curr_rec.past_year_from and g_curr_rec.past_year_to
55: and hzca.party_id IN
56: (SELECT p_filter_id FROM dual
57: UNION
58: SELECT ar.related_party_id
59: FROM ar_paying_relationships_v ar
60: WHERE ar.party_id = p_filter_id
341: -- WHERE JII.resource_id = JRREV.resource_id
342: -- AND JIOV.Outcome_id = JII.outcome_id
343: -- AND JIRV.Result_id(+) = JII.result_id
344: -- AND JII.Party_Id IN
345: -- (SELECT p_party_id FROM dual
346: -- UNION
347: -- SELECT ar.related_party_id
348: -- FROM ar_paying_relationships_v ar
349: -- WHERE ar.party_id = p_party_id
368: AND JIOV.LANGUAGE (+)= USERENV('LANG')
369: AND JIRV.Result_id(+) = JII.result_id
370: AND JIRV.LANGUAGE (+)= USERENV('LANG')
371: AND JII.Party_Id IN
372: (SELECT p_party_id FROM dual
373: UNION
374: SELECT ar.related_party_id
375: FROM ar_paying_relationships_v ar
376: WHERE ar.party_id = p_party_id
544: SELECT TRUNC(add_months(sysdate, - 12)) pastYearFrom ,
545: TRUNC(sysdate) pastYearTo
546: INTO g_curr_rec.past_year_from,
547: g_curr_rec.past_year_to
548: FROM dual;
549:
550: --Bug4562698. Moved the Constructor to GET_PROFILE_INFO. End.
551:
552:
578: WHERE IPD.cust_account_id = HZCA.cust_Account_id
579: AND IPD.DELINQUENCY_ID = DEL.DELINQUENCY_ID
580: AND trunc(IPD.CREATION_DATE) BETWEEN g_curr_rec.past_year_from AND g_curr_rec.past_year_to
581: AND HZCA.Party_id IN
582: (SELECT p_party_id FROM dual
583: UNION
584: SELECT ar.related_party_id
585: FROM ar_paying_relationships_v ar
586: WHERE ar.party_id = p_party_id
854: SELECT TRUNC(add_months(sysdate, - 12)) pastYearFrom ,
855: TRUNC(sysdate) pastYearTo
856: INTO g_curr_rec.past_year_from,
857: g_curr_rec.past_year_to
858: FROM dual; */
859: --Bug4562698. Moved the Constructor to GET_PROFILE_INFO. Begin
860:
861: END IEX_PROFILE;