DBA Data[Home] [Help]

APPS.PSB_VALIDATE_ACCT_PVT dependencies on PSB_ACCOUNT_POSITION_SET_LINES

Line 687: FROM psb_account_position_set_lines

683:
684: FOR l_line_e_rec IN
685: (
686: SELECT line_sequence_id, include_or_exclude_type
687: FROM psb_account_position_set_lines
688: WHERE account_position_set_id = p_aps_id
689: and include_or_exclude_type = 'E'
690: )
691: LOOP

Line 708: FROM psb_account_position_set_lines

704: IF l_excluded_flag = FND_API.G_FALSE then
705: FOR l_line_i_rec IN
706: (
707: SELECT line_sequence_id, include_or_exclude_type
708: FROM psb_account_position_set_lines
709: WHERE account_position_set_id = p_aps_id
710: and include_or_exclude_type = 'I'
711: )
712: LOOP

Line 750: ' psb_account_position_set_lines apsl ' ||

746: BEGIN
747:
748:
749: l_sql := ' SELECT count(*) FROM gl_code_combinations glcc, ' ||
750: ' psb_account_position_set_lines apsl ' ||
751: ' WHERE glcc.code_combination_id = :ccid ' ||
752: ' AND apsl.line_sequence_id = :line_sequence_id ' ||
753: ' AND glcc.enabled_flag = ''Y''' ||
754: ' AND glcc.detail_budgeting_allowed_flag = ''Y''' ||