DBA Data[Home] [Help]

APPS.PAY_CN_DEDUCTIONS dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 823: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

819: AND org_information3 IS NULL;
820:
821: l_found_flag VARCHAR2(1) ;
822: l_valid BOOLEAN := FALSE;
823: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
824: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
825: l_lookup_meaning hr_lookups.meaning%TYPE;
826: --
827: -- Start Bug 3038642

Line 824: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

820:
821: l_found_flag VARCHAR2(1) ;
822: l_valid BOOLEAN := FALSE;
823: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
824: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
825: l_lookup_meaning hr_lookups.meaning%TYPE;
826: --
827: -- Start Bug 3038642
828: --

Line 834: p_return_segment fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;

830: --
831: -- End Bug 3038642
832: --
833:
834: p_return_segment fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
835: p_ee_or_er VARCHAR2(2);
836:
837: BEGIN
838:

Line 1120: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

1116: AND org_information3 = p_phf_si_type
1117: AND org_information9 = p_hukou_type
1118: AND org_information2 IS NULL ;
1119:
1120: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
1121: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
1122: l_lookup_meaning hr_lookups.meaning%TYPE;
1123:
1124: --

Line 1121: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

1117: AND org_information9 = p_hukou_type
1118: AND org_information2 IS NULL ;
1119:
1120: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
1121: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
1122: l_lookup_meaning hr_lookups.meaning%TYPE;
1123:
1124: --
1125: -- End 3048748

Line 3994: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

3990: AS
3991:
3992: l_flag BOOLEAN;
3993: l_return_segment VARCHAR2(30);
3994: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
3995: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
3996: l_lookup_meaning hr_lookups.meaning%TYPE;
3997: l_lookup_meaning_dep hr_lookups.meaning%TYPE;
3998:

Line 3995: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

3991:
3992: l_flag BOOLEAN;
3993: l_return_segment VARCHAR2(30);
3994: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
3995: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
3996: l_lookup_meaning hr_lookups.meaning%TYPE;
3997: l_lookup_meaning_dep hr_lookups.meaning%TYPE;
3998:
3999:

Line 4303: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

4299: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
4300: )
4301: AS
4302:
4303: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
4304: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
4305: l_lookup_meaning hr_lookups.meaning%TYPE;
4306: l_lookup_meaning_dep hr_lookups.meaning%TYPE;
4307:

Line 4304: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

4300: )
4301: AS
4302:
4303: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
4304: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
4305: l_lookup_meaning hr_lookups.meaning%TYPE;
4306: l_lookup_meaning_dep hr_lookups.meaning%TYPE;
4307:
4308: BEGIN