APPS.PA_RETENTION_PKG dependencies on PA_LOOKUPS

Line 1246: l_revenue_category_meaning pa_lookups.meaning%TYPE;

1242:
1243: ELSIF retn_rule_rec.retention_level_code ='EVENT_TYPE' THEN
1244: /*The following code has been added to fix bug 3168266 */
1245: DECLARE
1246: l_revenue_category_meaning pa_lookups.meaning%TYPE;
1247: BEGIN
1248: SELECT meaning
1249: INTO l_revenue_category_meaning
1250: FROM pa_lookups

Line 1250: FROM pa_lookups

1246: l_revenue_category_meaning pa_lookups.meaning%TYPE;
1247: BEGIN
1248: SELECT meaning
1249: INTO l_revenue_category_meaning
1250: FROM pa_lookups
1251: WHERE lookup_code =retn_rule_rec.revenue_category_code
1252: AND lookup_type = 'REVENUE CATEGORY';
1253: RetnRuleText := RetnRuleText ||
1254: l_revenue_category_meaning|| ', ' ||

Line 1274: l_revenue_category_meaning1 pa_lookups.meaning%TYPE;

1270: ELSIF retn_rule_rec.retention_level_code ='REVENUE_CATEGORY'
1271: THEN
1272: /*The following code has been added to fix bug 3168266 */
1273: DECLARE
1274: l_revenue_category_meaning1 pa_lookups.meaning%TYPE;
1275: begin
1276: SELECT meaning
1277: INTO l_revenue_category_meaning1
1278: FROM pa_lookups

Line 1278: FROM pa_lookups

1274: l_revenue_category_meaning1 pa_lookups.meaning%TYPE;
1275: begin
1276: SELECT meaning
1277: INTO l_revenue_category_meaning1
1278: FROM pa_lookups
1279: WHERE lookup_code =retn_rule_rec.revenue_category_code
1280: AND lookup_type = 'REVENUE CATEGORY';
1281: RetnRuleText := RetnRuleText ||
1282: l_revenue_category_meaning1|| ', ' ||

Line 3148: from pa_lookups l,

3144: SET CANCELED_FLAG = 'Y',
3145: INVOICE_COMMENT =
3146: (select rtrim(upper(l.meaning)||' '||
3147: rtrim(SUBSTRB(i.invoice_comment,1,232)))
3148: from pa_lookups l,
3149: pa_draft_invoices i
3150: where i.project_Id = p_project_id
3151: and i.draft_invoice_num = p_draft_invoice_num
3152: and l.lookup_type = 'INVOICE_CREDIT_TYPE'