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 1122: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

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

Line 1123: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

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

Line 4109: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

4105: AS
4106:
4107: l_flag BOOLEAN;
4108: l_return_segment VARCHAR2(30);
4109: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
4110: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
4111: l_lookup_meaning hr_lookups.meaning%TYPE;
4112: l_lookup_meaning_dep hr_lookups.meaning%TYPE;
4113:

Line 4110: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

4106:
4107: l_flag BOOLEAN;
4108: l_return_segment VARCHAR2(30);
4109: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
4110: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
4111: l_lookup_meaning hr_lookups.meaning%TYPE;
4112: l_lookup_meaning_dep hr_lookups.meaning%TYPE;
4113:
4114:

Line 4418: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

4414: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
4415: )
4416: AS
4417:
4418: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
4419: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
4420: l_lookup_meaning hr_lookups.meaning%TYPE;
4421: l_lookup_meaning_dep hr_lookups.meaning%TYPE;
4422:

Line 4419: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

4415: )
4416: AS
4417:
4418: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
4419: l_dep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
4420: l_lookup_meaning hr_lookups.meaning%TYPE;
4421: l_lookup_meaning_dep hr_lookups.meaning%TYPE;
4422:
4423: BEGIN