APPS.PER_DATA_UPDATE_REPORT dependencies on PAY_UPGRADE_DEFINITIONS

Line 51: from pay_upgrade_definitions_tl

47: l_xfdf_blob OUT NOCOPY BLOB) AS
48: -- p_output_fname out nocopy varchar2) IS
49: cursor c_processes is
50: select name process_name
51: from pay_upgrade_definitions_tl
52: where language = userenv('LANG');
53:
54:
55: cursor c_get_process_data is

Line 79: from pay_upgrade_definitions_tl pudt,

75: app.DESCRIPTION application_name,
76: pud.VALIDATE_CODE validate_code,
77: pud.FIRST_PATCHSET introduced,
78: pud.ADDITIONAL_INFO additional_info
79: from pay_upgrade_definitions_tl pudt,
80: pay_upgrade_definitions pud,
81: fnd_application_vl app
82: where pud.owner_application_id = app.application_id (+)
83: and pudt.upgrade_definition_id = pud.upgrade_definition_id

Line 80: pay_upgrade_definitions pud,

76: pud.VALIDATE_CODE validate_code,
77: pud.FIRST_PATCHSET introduced,
78: pud.ADDITIONAL_INFO additional_info
79: from pay_upgrade_definitions_tl pudt,
80: pay_upgrade_definitions pud,
81: fnd_application_vl app
82: where pud.owner_application_id = app.application_id (+)
83: and pudt.upgrade_definition_id = pud.upgrade_definition_id
84: and ((pud.first_patchset like '%' || p_product || '%')

Line 127: l_process_name pay_upgrade_definitions_tl.name%type;

123: l_critCodeCShown boolean;
124: l_critCodeRShown boolean;
125: l_critCodeOShown boolean;
126: l_database_name varchar2(10);
127: l_process_name pay_upgrade_definitions_tl.name%type;
128: l_legislation_code pay_upgrade_definitions.legislation_code%type;
129: l_enabled_leg_code varchar2(150);
130: l_required varchar2(10);
131: l_prepatch varchar2(10);

Line 128: l_legislation_code pay_upgrade_definitions.legislation_code%type;

124: l_critCodeRShown boolean;
125: l_critCodeOShown boolean;
126: l_database_name varchar2(10);
127: l_process_name pay_upgrade_definitions_tl.name%type;
128: l_legislation_code pay_upgrade_definitions.legislation_code%type;
129: l_enabled_leg_code varchar2(150);
130: l_required varchar2(10);
131: l_prepatch varchar2(10);
132: l_inpatch varchar2(10);