DBA Data[Home] [Help]

APPS.PY_ZA_BAL dependencies on FF_ROUTES_S

Line 3019: ff_routes_s.NEXTVAL,

3015: text
3016: )
3017: VALUES
3018: (
3019: ff_routes_s.NEXTVAL,
3020: 'ROUTE_NAME_' || ff_routes_s.CURRVAL ,
3021: 'N',
3022: 'User balance dimension for '||
3023: UPPER(RPAD(p_suffix,30,' ')) || 'USER-REG ASG '||

Line 3020: 'ROUTE_NAME_' || ff_routes_s.CURRVAL ,

3016: )
3017: VALUES
3018: (
3019: ff_routes_s.NEXTVAL,
3020: 'ROUTE_NAME_' || ff_routes_s.CURRVAL ,
3021: 'N',
3022: 'User balance dimension for '||
3023: UPPER(RPAD(p_suffix,30,' ')) || 'USER-REG ASG '||
3024: p_start_dd_mm || ' RESET'|| TO_CHAR(p_frequency,'00'),

Line 3041: ff_routes_s.CURRVAL,

3037: context_id,
3038: sequence_no
3039: )
3040: SELECT
3041: ff_routes_s.CURRVAL,
3042: context_id,
3043: 1
3044: FROM
3045: ff_contexts

Line 3066: ff_routes_s.CURRVAL,

3062: )
3063: VALUES
3064: (
3065: ff_route_parameters_s.NEXTVAL,
3066: ff_routes_s.CURRVAL,
3067: 1,
3068: 'BALANCE TYPE ID',
3069: 'N'
3070: );

Line 3146: ff_routes_s.CURRVAL,

3142: (
3143: pay_balance_dimensions_s.CURRVAL,
3144: p_business_group_id,
3145: NULL,
3146: ff_routes_s.CURRVAL,
3147: p_suffix,
3148: l_dim_name,
3149: l_dim_type,
3150: 'User dimension defined by Request Id ' || l_req_id,