[Home] [Help]
53: where aps.customer_id = hzca.cust_account_id
54: and aps.class IN ('INV', 'DM', 'CB')
55: and aps.due_date between g_curr_rec.past_year_from and g_curr_rec.past_year_to
56: and hzca.party_id IN
57: (SELECT p_filter_id FROM dual
58: UNION
59: SELECT ar.related_party_id
60: FROM ar_paying_relationships_v ar
61: WHERE ar.party_id = p_filter_id
413: -- WHERE JII.resource_id = JRREV.resource_id
414: -- AND JIOV.Outcome_id = JII.outcome_id
415: -- AND JIRV.Result_id(+) = JII.result_id
416: -- AND JII.Party_Id IN
417: -- (SELECT p_party_id FROM dual
418: -- UNION
419: -- SELECT ar.related_party_id
420: -- FROM ar_paying_relationships_v ar
421: -- WHERE ar.party_id = p_party_id
440: AND JIOV.LANGUAGE (+)= USERENV('LANG')
441: AND JIRV.Result_id(+) = JII.result_id
442: AND JIRV.LANGUAGE (+)= USERENV('LANG')
443: AND JII.Party_Id IN
444: (SELECT p_party_id FROM dual
445: UNION
446: SELECT ar.related_party_id
447: FROM ar_paying_relationships_v ar
448: WHERE ar.party_id = p_party_id
662: SELECT TRUNC(add_months(sysdate, - 12)) pastYearFrom ,
663: TRUNC(sysdate) pastYearTo
664: INTO g_curr_rec.past_year_from,
665: g_curr_rec.past_year_to
666: FROM dual;
667:
668: --Bug4562698. Moved the Constructor to GET_PROFILE_INFO. End.
669:
670:
696: WHERE IPD.cust_account_id = HZCA.cust_Account_id
697: AND IPD.DELINQUENCY_ID = DEL.DELINQUENCY_ID
698: AND trunc(IPD.CREATION_DATE) BETWEEN g_curr_rec.past_year_from AND g_curr_rec.past_year_to
699: AND HZCA.Party_id IN
700: (SELECT p_party_id FROM dual
701: UNION
702: SELECT ar.related_party_id
703: FROM ar_paying_relationships_v ar
704: WHERE ar.party_id = p_party_id
1043: SELECT TRUNC(add_months(sysdate, - 12)) pastYearFrom ,
1044: TRUNC(sysdate) pastYearTo
1045: INTO g_curr_rec.past_year_from,
1046: g_curr_rec.past_year_to
1047: FROM dual; */
1048: --Bug4562698. Moved the Constructor to GET_PROFILE_INFO. Begin
1049:
1050: END IEX_PROFILE;