565: l_currency_code VARCHAR2(15);
566: --
567: CURSOR currency_csr (p_currency_code IN VARCHAR2, p_distribution_date IN DATE )IS
568: SELECT fc.currency_code
569: FROM fnd_currencies fc,
570: per_business_groups pbg
571: WHERE fc.currency_code =pbg.currency_code
572: AND fc.enabled_flag = 'Y'
573: AND fc.currency_flag = 'Y'
1011: AND p_distribution_date between papf.effective_start_date and papf.effective_end_date;
1012:
1013: CURSOR currency_csr (p_currency_code IN VARCHAR2, p_distribution_date IN DATE )IS
1014: SELECT fc.currency_code
1015: FROM fnd_currencies fc,
1016: per_business_groups pbg
1017: WHERE fc.currency_code =pbg.currency_code
1018: AND fc.enabled_flag = 'Y'
1019: AND fc.currency_flag = 'Y'