[Home] [Help]
339: where business_group_id = p_business_group_id;
340:
341: Cursor C_pos_segs is
342: select application_column_name
343: from fnd_id_flex_segments_vl
344: where id_flex_code = 'POS'
345: and id_flex_num = l_pos_id_flex_num
346: and enabled_flag = 'Y'
347: order by segment_num;
2390: WHERE payroll_id = l_payroll_id
2391: AND gl_set_of_books_id = p_set_of_books_id
2392: AND gl_account_segment in
2393: ( SELECT application_column_name
2394: FROM fnd_id_flex_segments_vl
2395: WHERE id_flex_code = l_id_flex_code -- bug #4924031
2396: AND application_id = l_application_id -- bug #4924031
2397: AND enabled_flag = l_yes_flag -- bug #4924031
2398: AND id_flex_num = l_chart_of_accounts_id )
2440: and hru.cost_allocation_keyflex_id = pcak.cost_allocation_keyflex_id;
2441:
2442: Cursor C_Segcount is
2443: SELECT count(*) seg_count
2444: FROM fnd_id_flex_segments_vl
2445: WHERE id_flex_code = l_id_flex_code -- bug #4924031
2446: AND application_id = l_application_id -- bug #4924031
2447: AND enabled_flag = l_yes_flag -- bug #4924031
2448: AND id_flex_num = l_chart_of_accounts_id;
3596:
3597: Cursor C_key_22 is
3598: SELECT fstr.id_flex_num, fseg.application_column_name,
3599: fseg.flex_value_set_id
3600: FROM fnd_id_flex_structures_vl fstr,fnd_id_flex_segments_vl fseg
3601: WHERE fstr.application_id = l_application_id
3602: AND fstr.id_flex_code = l_id_flex_code
3603: AND fstr.id_flex_structure_name = l_definition_table
3604: AND fstr.id_flex_code = fseg.id_flex_code
4597:
4598: Cursor C_key_44 is
4599: SELECT fseg.application_column_name,
4600: fstr.id_flex_num
4601: FROM fnd_id_flex_structures_vl fstr,fnd_id_flex_segments_vl fseg
4602: WHERE fstr.application_id = l_application_id
4603: AND fstr.id_flex_code = l_id_flex_code
4604: AND fstr.id_flex_structure_name = l_definition_table
4605: AND fstr.id_flex_code = fseg.id_flex_code