eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FR_ARC_PKG dependencies on FND_LOOKUP_VALUES

Line 85: g_retro_tl fnd_lookup_values.meaning%TYPE := 'Default Retro';

81: g_us_name_rate varchar2(10) := 'Rate';
82: g_us_name_base varchar2(10) := 'Base';
83: g_us_name_start_date varchar2(10) := 'Start Date';
84: g_us_name_end_date varchar2(10) := 'End Date';
85: g_retro_tl fnd_lookup_values.meaning%TYPE := 'Default Retro';
86: g_fr_name_pay_value fnd_lookup_values.meaning%TYPE;
87: g_fr_name_rate fnd_lookup_values.meaning%TYPE;
88: g_fr_name_base fnd_lookup_values.meaning%TYPE;
89: g_fr_name_start_date fnd_lookup_values.meaning%TYPE;

Line 86: g_fr_name_pay_value fnd_lookup_values.meaning%TYPE;

82: g_us_name_base varchar2(10) := 'Base';
83: g_us_name_start_date varchar2(10) := 'Start Date';
84: g_us_name_end_date varchar2(10) := 'End Date';
85: g_retro_tl fnd_lookup_values.meaning%TYPE := 'Default Retro';
86: g_fr_name_pay_value fnd_lookup_values.meaning%TYPE;
87: g_fr_name_rate fnd_lookup_values.meaning%TYPE;
88: g_fr_name_base fnd_lookup_values.meaning%TYPE;
89: g_fr_name_start_date fnd_lookup_values.meaning%TYPE;
90: g_fr_name_end_date fnd_lookup_values.meaning%TYPE;

Line 87: g_fr_name_rate fnd_lookup_values.meaning%TYPE;

83: g_us_name_start_date varchar2(10) := 'Start Date';
84: g_us_name_end_date varchar2(10) := 'End Date';
85: g_retro_tl fnd_lookup_values.meaning%TYPE := 'Default Retro';
86: g_fr_name_pay_value fnd_lookup_values.meaning%TYPE;
87: g_fr_name_rate fnd_lookup_values.meaning%TYPE;
88: g_fr_name_base fnd_lookup_values.meaning%TYPE;
89: g_fr_name_start_date fnd_lookup_values.meaning%TYPE;
90: g_fr_name_end_date fnd_lookup_values.meaning%TYPE;
91: --

Line 88: g_fr_name_base fnd_lookup_values.meaning%TYPE;

84: g_us_name_end_date varchar2(10) := 'End Date';
85: g_retro_tl fnd_lookup_values.meaning%TYPE := 'Default Retro';
86: g_fr_name_pay_value fnd_lookup_values.meaning%TYPE;
87: g_fr_name_rate fnd_lookup_values.meaning%TYPE;
88: g_fr_name_base fnd_lookup_values.meaning%TYPE;
89: g_fr_name_start_date fnd_lookup_values.meaning%TYPE;
90: g_fr_name_end_date fnd_lookup_values.meaning%TYPE;
91: --
92: --

Line 89: g_fr_name_start_date fnd_lookup_values.meaning%TYPE;

85: g_retro_tl fnd_lookup_values.meaning%TYPE := 'Default Retro';
86: g_fr_name_pay_value fnd_lookup_values.meaning%TYPE;
87: g_fr_name_rate fnd_lookup_values.meaning%TYPE;
88: g_fr_name_base fnd_lookup_values.meaning%TYPE;
89: g_fr_name_start_date fnd_lookup_values.meaning%TYPE;
90: g_fr_name_end_date fnd_lookup_values.meaning%TYPE;
91: --
92: --
93: g_source_text ff_contexts.context_id%TYPE;

Line 90: g_fr_name_end_date fnd_lookup_values.meaning%TYPE;

86: g_fr_name_pay_value fnd_lookup_values.meaning%TYPE;
87: g_fr_name_rate fnd_lookup_values.meaning%TYPE;
88: g_fr_name_base fnd_lookup_values.meaning%TYPE;
89: g_fr_name_start_date fnd_lookup_values.meaning%TYPE;
90: g_fr_name_end_date fnd_lookup_values.meaning%TYPE;
91: --
92: --
93: g_source_text ff_contexts.context_id%TYPE;
94: --

Line 123: g_sec_grp_id_user_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;

119: g_ele_class_Net_EE_Deductions pay_element_classifications.classification_id%TYPE;
120: g_ele_class_ER_LV_Charges pay_element_classifications.classification_id%TYPE;
121: --
122: -- Globals added for security groups (bug 3683906)
123: g_sec_grp_id_user_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
124: g_sec_grp_id_base_unit FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
125: g_sec_grp_id_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
126: -- more added for bug 4778143:
127: g_sec_grp_id_process_type FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;

Line 124: g_sec_grp_id_base_unit FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;

120: g_ele_class_ER_LV_Charges pay_element_classifications.classification_id%TYPE;
121: --
122: -- Globals added for security groups (bug 3683906)
123: g_sec_grp_id_user_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
124: g_sec_grp_id_base_unit FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
125: g_sec_grp_id_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
126: -- more added for bug 4778143:
127: g_sec_grp_id_process_type FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
128: g_sec_grp_id_fixed_time_units FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;

Line 125: g_sec_grp_id_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;

121: --
122: -- Globals added for security groups (bug 3683906)
123: g_sec_grp_id_user_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
124: g_sec_grp_id_base_unit FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
125: g_sec_grp_id_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
126: -- more added for bug 4778143:
127: g_sec_grp_id_process_type FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
128: g_sec_grp_id_fixed_time_units FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
129: g_sec_grp_id_fixed_time_freq FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;

Line 127: g_sec_grp_id_process_type FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;

123: g_sec_grp_id_user_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
124: g_sec_grp_id_base_unit FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
125: g_sec_grp_id_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
126: -- more added for bug 4778143:
127: g_sec_grp_id_process_type FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
128: g_sec_grp_id_fixed_time_units FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
129: g_sec_grp_id_fixed_time_freq FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
130: --
131: ---------------------------------------------------------------------------------------------------

Line 128: g_sec_grp_id_fixed_time_units FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;

124: g_sec_grp_id_base_unit FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
125: g_sec_grp_id_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
126: -- more added for bug 4778143:
127: g_sec_grp_id_process_type FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
128: g_sec_grp_id_fixed_time_units FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
129: g_sec_grp_id_fixed_time_freq FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
130: --
131: ---------------------------------------------------------------------------------------------------
132: -- ARCHIVE HOOK POINTS

Line 129: g_sec_grp_id_fixed_time_freq FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;

125: g_sec_grp_id_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
126: -- more added for bug 4778143:
127: g_sec_grp_id_process_type FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
128: g_sec_grp_id_fixed_time_units FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
129: g_sec_grp_id_fixed_time_freq FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
130: --
131: ---------------------------------------------------------------------------------------------------
132: -- ARCHIVE HOOK POINTS
133: --

Line 600: l_term_reason fnd_lookup_values.meaning%TYPE;

596: l_ovn number (15);
597: l_archive_type varchar2(3) := 'AAP';
598: l_latest_process_type varchar2(30);
599: l_ee_info_id pay_action_information.action_information_id%TYPE;
600: l_term_reason fnd_lookup_values.meaning%TYPE;
601: l_term_pay_schedule fnd_lookup_values.lookup_code%TYPE;
602: l_term_atd date;
603: l_term_lwd date;
604: --

Line 601: l_term_pay_schedule fnd_lookup_values.lookup_code%TYPE;

597: l_archive_type varchar2(3) := 'AAP';
598: l_latest_process_type varchar2(30);
599: l_ee_info_id pay_action_information.action_information_id%TYPE;
600: l_term_reason fnd_lookup_values.meaning%TYPE;
601: l_term_pay_schedule fnd_lookup_values.lookup_code%TYPE;
602: l_term_atd date;
603: l_term_lwd date;
604: --
605: -- variables to hold totals values, passed back from various functions

Line 853: l_text1 fnd_lookup_values.meaning%TYPE;

849: l_action_info_id number(15);
850: l_archive_type varchar2(3) := 'PA';
851: l_ovn number (15);
852: l_proc VARCHAR2(40):= g_package||' load payslip text ';
853: l_text1 fnd_lookup_values.meaning%TYPE;
854: l_text2 fnd_lookup_values.meaning%TYPE;
855: l_text3 fnd_lookup_values.meaning%TYPE;
856: l_text4 fnd_lookup_values.meaning%TYPE;
857: l_text5 fnd_lookup_values.meaning%TYPE;

Line 854: l_text2 fnd_lookup_values.meaning%TYPE;

850: l_archive_type varchar2(3) := 'PA';
851: l_ovn number (15);
852: l_proc VARCHAR2(40):= g_package||' load payslip text ';
853: l_text1 fnd_lookup_values.meaning%TYPE;
854: l_text2 fnd_lookup_values.meaning%TYPE;
855: l_text3 fnd_lookup_values.meaning%TYPE;
856: l_text4 fnd_lookup_values.meaning%TYPE;
857: l_text5 fnd_lookup_values.meaning%TYPE;
858: l_text6 fnd_lookup_values.meaning%TYPE;

Line 855: l_text3 fnd_lookup_values.meaning%TYPE;

851: l_ovn number (15);
852: l_proc VARCHAR2(40):= g_package||' load payslip text ';
853: l_text1 fnd_lookup_values.meaning%TYPE;
854: l_text2 fnd_lookup_values.meaning%TYPE;
855: l_text3 fnd_lookup_values.meaning%TYPE;
856: l_text4 fnd_lookup_values.meaning%TYPE;
857: l_text5 fnd_lookup_values.meaning%TYPE;
858: l_text6 fnd_lookup_values.meaning%TYPE;
859: l_text7 fnd_lookup_values.meaning%TYPE;

Line 856: l_text4 fnd_lookup_values.meaning%TYPE;

852: l_proc VARCHAR2(40):= g_package||' load payslip text ';
853: l_text1 fnd_lookup_values.meaning%TYPE;
854: l_text2 fnd_lookup_values.meaning%TYPE;
855: l_text3 fnd_lookup_values.meaning%TYPE;
856: l_text4 fnd_lookup_values.meaning%TYPE;
857: l_text5 fnd_lookup_values.meaning%TYPE;
858: l_text6 fnd_lookup_values.meaning%TYPE;
859: l_text7 fnd_lookup_values.meaning%TYPE;
860: l_text8 fnd_lookup_values.meaning%TYPE;

Line 857: l_text5 fnd_lookup_values.meaning%TYPE;

853: l_text1 fnd_lookup_values.meaning%TYPE;
854: l_text2 fnd_lookup_values.meaning%TYPE;
855: l_text3 fnd_lookup_values.meaning%TYPE;
856: l_text4 fnd_lookup_values.meaning%TYPE;
857: l_text5 fnd_lookup_values.meaning%TYPE;
858: l_text6 fnd_lookup_values.meaning%TYPE;
859: l_text7 fnd_lookup_values.meaning%TYPE;
860: l_text8 fnd_lookup_values.meaning%TYPE;
861: l_text9 fnd_lookup_values.meaning%TYPE;

Line 858: l_text6 fnd_lookup_values.meaning%TYPE;

854: l_text2 fnd_lookup_values.meaning%TYPE;
855: l_text3 fnd_lookup_values.meaning%TYPE;
856: l_text4 fnd_lookup_values.meaning%TYPE;
857: l_text5 fnd_lookup_values.meaning%TYPE;
858: l_text6 fnd_lookup_values.meaning%TYPE;
859: l_text7 fnd_lookup_values.meaning%TYPE;
860: l_text8 fnd_lookup_values.meaning%TYPE;
861: l_text9 fnd_lookup_values.meaning%TYPE;
862: l_text10 fnd_lookup_values.meaning%TYPE;

Line 859: l_text7 fnd_lookup_values.meaning%TYPE;

855: l_text3 fnd_lookup_values.meaning%TYPE;
856: l_text4 fnd_lookup_values.meaning%TYPE;
857: l_text5 fnd_lookup_values.meaning%TYPE;
858: l_text6 fnd_lookup_values.meaning%TYPE;
859: l_text7 fnd_lookup_values.meaning%TYPE;
860: l_text8 fnd_lookup_values.meaning%TYPE;
861: l_text9 fnd_lookup_values.meaning%TYPE;
862: l_text10 fnd_lookup_values.meaning%TYPE;
863: l_text11 fnd_lookup_values.meaning%TYPE;

Line 860: l_text8 fnd_lookup_values.meaning%TYPE;

856: l_text4 fnd_lookup_values.meaning%TYPE;
857: l_text5 fnd_lookup_values.meaning%TYPE;
858: l_text6 fnd_lookup_values.meaning%TYPE;
859: l_text7 fnd_lookup_values.meaning%TYPE;
860: l_text8 fnd_lookup_values.meaning%TYPE;
861: l_text9 fnd_lookup_values.meaning%TYPE;
862: l_text10 fnd_lookup_values.meaning%TYPE;
863: l_text11 fnd_lookup_values.meaning%TYPE;
864: l_text12 fnd_lookup_values.meaning%TYPE;

Line 861: l_text9 fnd_lookup_values.meaning%TYPE;

857: l_text5 fnd_lookup_values.meaning%TYPE;
858: l_text6 fnd_lookup_values.meaning%TYPE;
859: l_text7 fnd_lookup_values.meaning%TYPE;
860: l_text8 fnd_lookup_values.meaning%TYPE;
861: l_text9 fnd_lookup_values.meaning%TYPE;
862: l_text10 fnd_lookup_values.meaning%TYPE;
863: l_text11 fnd_lookup_values.meaning%TYPE;
864: l_text12 fnd_lookup_values.meaning%TYPE;
865: BEGIN

Line 862: l_text10 fnd_lookup_values.meaning%TYPE;

858: l_text6 fnd_lookup_values.meaning%TYPE;
859: l_text7 fnd_lookup_values.meaning%TYPE;
860: l_text8 fnd_lookup_values.meaning%TYPE;
861: l_text9 fnd_lookup_values.meaning%TYPE;
862: l_text10 fnd_lookup_values.meaning%TYPE;
863: l_text11 fnd_lookup_values.meaning%TYPE;
864: l_text12 fnd_lookup_values.meaning%TYPE;
865: BEGIN
866: --

Line 863: l_text11 fnd_lookup_values.meaning%TYPE;

859: l_text7 fnd_lookup_values.meaning%TYPE;
860: l_text8 fnd_lookup_values.meaning%TYPE;
861: l_text9 fnd_lookup_values.meaning%TYPE;
862: l_text10 fnd_lookup_values.meaning%TYPE;
863: l_text11 fnd_lookup_values.meaning%TYPE;
864: l_text12 fnd_lookup_values.meaning%TYPE;
865: BEGIN
866: --
867: -- Load the TOTALS bolierplate text

Line 864: l_text12 fnd_lookup_values.meaning%TYPE;

860: l_text8 fnd_lookup_values.meaning%TYPE;
861: l_text9 fnd_lookup_values.meaning%TYPE;
862: l_text10 fnd_lookup_values.meaning%TYPE;
863: l_text11 fnd_lookup_values.meaning%TYPE;
864: l_text12 fnd_lookup_values.meaning%TYPE;
865: BEGIN
866: --
867: -- Load the TOTALS bolierplate text
868: --

Line 1674: ,fnd_lookup_values hrl

1670: ,hr_all_organization_units est
1671: ,hr_organization_information estinfo
1672: ,hr_all_organization_units_tl orgtl
1673: ,per_contracts_f ctr
1674: ,fnd_lookup_values hrl
1675: ,fnd_lookup_values hrl1
1676: where asg.assignment_id = p_assignment_id
1677: and p_asat_date between asg.effective_start_date
1678: and asg.effective_end_date

Line 1675: ,fnd_lookup_values hrl1

1671: ,hr_organization_information estinfo
1672: ,hr_all_organization_units_tl orgtl
1673: ,per_contracts_f ctr
1674: ,fnd_lookup_values hrl
1675: ,fnd_lookup_values hrl1
1676: where asg.assignment_id = p_assignment_id
1677: and p_asat_date between asg.effective_start_date
1678: and asg.effective_end_date
1679: and asg.establishment_id = est.organization_id

Line 2406: ,fnd_lookup_values user_rubric

2402: ,pay_run_results prr
2403: ,pay_element_types_f pet
2404: ,pay_element_classifications pec
2405: ,pay_input_values_f_tl piv
2406: ,fnd_lookup_values user_rubric
2407: ,fnd_lookup_values seed_rubric
2408: ,fnd_lookup_values base_units
2409: ,pay_payroll_actions pre_payact
2410: ,pay_assignment_actions pre_assact

Line 2407: ,fnd_lookup_values seed_rubric

2403: ,pay_element_types_f pet
2404: ,pay_element_classifications pec
2405: ,pay_input_values_f_tl piv
2406: ,fnd_lookup_values user_rubric
2407: ,fnd_lookup_values seed_rubric
2408: ,fnd_lookup_values base_units
2409: ,pay_payroll_actions pre_payact
2410: ,pay_assignment_actions pre_assact
2411: ,pay_payroll_actions run_payact

Line 2408: ,fnd_lookup_values base_units

2404: ,pay_element_classifications pec
2405: ,pay_input_values_f_tl piv
2406: ,fnd_lookup_values user_rubric
2407: ,fnd_lookup_values seed_rubric
2408: ,fnd_lookup_values base_units
2409: ,pay_payroll_actions pre_payact
2410: ,pay_assignment_actions pre_assact
2411: ,pay_payroll_actions run_payact
2412: ,pay_assignment_actions run_assact

Line 2523: from fnd_lookup_values

2519: ,sum(base_value);
2520:
2521: cursor csr_process_meaning (p_process_type varchar2) is
2522: select upper(meaning)
2523: from fnd_lookup_values
2524: where lookup_type = 'FR_PROCESS_TYPE'
2525: and view_application_id = 3
2526: and lookup_code = p_process_type
2527: and security_group_id = g_sec_grp_id_process_type

Line 3025: ,fnd_lookup_values user_rubric

3021: from pay_element_types_f pet
3022: ,pay_run_results prr
3023: ,pay_input_values_f piv
3024: ,pay_run_result_values prrv
3025: ,fnd_lookup_values user_rubric
3026: ,fnd_lookup_values seed_rubric
3027: ,fnd_lookup_values base_units
3028: ,pay_action_interlocks arc_lock
3029: ,pay_action_interlocks pre_lock

Line 3026: ,fnd_lookup_values seed_rubric

3022: ,pay_run_results prr
3023: ,pay_input_values_f piv
3024: ,pay_run_result_values prrv
3025: ,fnd_lookup_values user_rubric
3026: ,fnd_lookup_values seed_rubric
3027: ,fnd_lookup_values base_units
3028: ,pay_action_interlocks arc_lock
3029: ,pay_action_interlocks pre_lock
3030: ,pay_assignment_actions run_assact

Line 3027: ,fnd_lookup_values base_units

3023: ,pay_input_values_f piv
3024: ,pay_run_result_values prrv
3025: ,fnd_lookup_values user_rubric
3026: ,fnd_lookup_values seed_rubric
3027: ,fnd_lookup_values base_units
3028: ,pay_action_interlocks arc_lock
3029: ,pay_action_interlocks pre_lock
3030: ,pay_assignment_actions run_assact
3031: ,pay_payroll_actions run_payact

Line 3413: l_this_process_type fnd_lookup_values.meaning%TYPE;

3409: -- l_sec_grp_id_user_ele_grp number;
3410: -- l_sec_grp_id_ele_grp number;
3411: --
3412: l_proc VARCHAR2(60):= g_package||' Load Deductions ';
3413: l_this_process_type fnd_lookup_values.meaning%TYPE;
3414: l_proc_type fnd_lookup_values.lookup_code%TYPE;
3415: l_proc_type_meaning fnd_lookup_values.meaning%TYPE;
3416: l_total_ee_deductions number(15,2) := 0.00;
3417: l_total_er_deductions number(15,2) := 0.00;

Line 3414: l_proc_type fnd_lookup_values.lookup_code%TYPE;

3410: -- l_sec_grp_id_ele_grp number;
3411: --
3412: l_proc VARCHAR2(60):= g_package||' Load Deductions ';
3413: l_this_process_type fnd_lookup_values.meaning%TYPE;
3414: l_proc_type fnd_lookup_values.lookup_code%TYPE;
3415: l_proc_type_meaning fnd_lookup_values.meaning%TYPE;
3416: l_total_ee_deductions number(15,2) := 0.00;
3417: l_total_er_deductions number(15,2) := 0.00;
3418: l_total_ee_csg number(15,2) := 0.00;

Line 3415: l_proc_type_meaning fnd_lookup_values.meaning%TYPE;

3411: --
3412: l_proc VARCHAR2(60):= g_package||' Load Deductions ';
3413: l_this_process_type fnd_lookup_values.meaning%TYPE;
3414: l_proc_type fnd_lookup_values.lookup_code%TYPE;
3415: l_proc_type_meaning fnd_lookup_values.meaning%TYPE;
3416: l_total_ee_deductions number(15,2) := 0.00;
3417: l_total_er_deductions number(15,2) := 0.00;
3418: l_total_ee_csg number(15,2) := 0.00;
3419: l_context varchar2(20) := 'FR_SOE_ELEMENTS';

Line 3423: l_group_code fnd_lookup_values.lookup_code%TYPE;

3419: l_context varchar2(20) := 'FR_SOE_ELEMENTS';
3420: l_action_info_id pay_action_information.action_information_id%TYPE;
3421: l_ovn pay_action_information.object_version_number%TYPE;
3422: l_archive_type varchar2(3) := 'AAP';
3423: l_group_code fnd_lookup_values.lookup_code%TYPE;
3424: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
3425: l_rubric fnd_lookup_values.tag%TYPE;
3426: l_description fnd_lookup_values.meaning%TYPE;
3427: l_retro_tl fnd_lookup_values.meaning%TYPE;

Line 3425: l_rubric fnd_lookup_values.tag%TYPE;

3421: l_ovn pay_action_information.object_version_number%TYPE;
3422: l_archive_type varchar2(3) := 'AAP';
3423: l_group_code fnd_lookup_values.lookup_code%TYPE;
3424: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
3425: l_rubric fnd_lookup_values.tag%TYPE;
3426: l_description fnd_lookup_values.meaning%TYPE;
3427: l_retro_tl fnd_lookup_values.meaning%TYPE;
3428: --
3429: l_append_dates varchar2(150); /* temp area for for constructing dd-mm - dd-mm */

Line 3426: l_description fnd_lookup_values.meaning%TYPE;

3422: l_archive_type varchar2(3) := 'AAP';
3423: l_group_code fnd_lookup_values.lookup_code%TYPE;
3424: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
3425: l_rubric fnd_lookup_values.tag%TYPE;
3426: l_description fnd_lookup_values.meaning%TYPE;
3427: l_retro_tl fnd_lookup_values.meaning%TYPE;
3428: --
3429: l_append_dates varchar2(150); /* temp area for for constructing dd-mm - dd-mm */
3430: --

Line 3427: l_retro_tl fnd_lookup_values.meaning%TYPE;

3423: l_group_code fnd_lookup_values.lookup_code%TYPE;
3424: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
3425: l_rubric fnd_lookup_values.tag%TYPE;
3426: l_description fnd_lookup_values.meaning%TYPE;
3427: l_retro_tl fnd_lookup_values.meaning%TYPE;
3428: --
3429: l_append_dates varchar2(150); /* temp area for for constructing dd-mm - dd-mm */
3430: --
3431: cursor csr_get_run_bals is

Line 3650: from fnd_lookup_values

3646:
3647: --
3648: cursor csr_process_meaning (p_process_type varchar2) is
3649: select upper(meaning)
3650: from fnd_lookup_values
3651: where lookup_type = 'FR_PROCESS_TYPE'
3652: and view_application_id = 3
3653: and lookup_code = p_process_type
3654: and security_group_id = g_sec_grp_id_process_type

Line 3662: from fnd_lookup_values

3658: cursor csr_get_rubric(p_group_code varchar2,
3659: p_sec_grp_id_ele_grp number,
3660: p_sec_grp_id_user_ele_grp number) is
3661: select tag ,meaning
3662: from fnd_lookup_values
3663: where ((lookup_type = 'FR_ELEMENT_GROUP'
3664: and security_group_id = p_sec_grp_id_ele_grp)
3665: OR (lookup_type = 'FR_USER_ELEMENT_GROUP'
3666: and security_group_id = p_sec_grp_id_user_ele_grp))