APPS.HRDYNDBI dependencies on PAY_PAYMENT_TYPES

Line 7045: l_context pay_payment_types.payment_type_name%type;

7041: cursor get_title is
7042: select rtrim(title,'.') from fnd_descriptive_flexs_vl
7043: where descriptive_flexfield_name = 'Paymeth Developer DF';
7044: --
7045: l_context pay_payment_types.payment_type_name%type;
7046: l_context_upper pay_payment_types.payment_type_name%type;
7047: l_title varchar2(80);
7048: --
7049: ---------------------- create_org_pay_flex_dict -------------------------

Line 7046: l_context_upper pay_payment_types.payment_type_name%type;

7042: select rtrim(title,'.') from fnd_descriptive_flexs_vl
7043: where descriptive_flexfield_name = 'Paymeth Developer DF';
7044: --
7045: l_context pay_payment_types.payment_type_name%type;
7046: l_context_upper pay_payment_types.payment_type_name%type;
7047: l_title varchar2(80);
7048: --
7049: ---------------------- create_org_pay_flex_dict -------------------------
7050: --

Line 7057: from pay_payment_types

7053: -- get the context
7054: --
7055: select payment_type_name
7056: into l_context
7057: from pay_payment_types
7058: where payment_type_id = p_payment_id;
7059: --
7060: open get_title;
7061: fetch get_title into l_title;

Line 7116: l_context pay_payment_types.payment_type_name%type;

7112: cursor get_title is
7113: select rtrim(title,'.') from fnd_descriptive_flexs_vl
7114: where descriptive_flexfield_name = 'Personal PayMeth Developer DF';
7115:
7116: l_context pay_payment_types.payment_type_name%type;
7117: l_context_upper pay_payment_types.payment_type_name%type;
7118: l_title varchar2(80);
7119:
7120: begin

Line 7117: l_context_upper pay_payment_types.payment_type_name%type;

7113: select rtrim(title,'.') from fnd_descriptive_flexs_vl
7114: where descriptive_flexfield_name = 'Personal PayMeth Developer DF';
7115:
7116: l_context pay_payment_types.payment_type_name%type;
7117: l_context_upper pay_payment_types.payment_type_name%type;
7118: l_title varchar2(80);
7119:
7120: begin
7121: select nvl(territory_code, 'ZZ')||'_'||payment_type_name

Line 7123: from pay_payment_types

7119:
7120: begin
7121: select nvl(territory_code, 'ZZ')||'_'||payment_type_name
7122: into l_context
7123: from pay_payment_types
7124: where payment_type_id = p_payment_id;
7125: --
7126: open get_title;
7127: fetch get_title into l_title;