APPS.PAY_USER_ROWS_PKG dependencies on PAY_USER_ROWS_F_TL

Line 474: delete from PAY_USER_ROWS_F_TL T

470: --For MLS-----------------------------------------------------------------------
471: procedure ADD_LANGUAGE
472: is
473: begin
474: delete from PAY_USER_ROWS_F_TL T
475: where not exists
476: (select NULL
477: from PAY_USER_ROWS_F B
478: where B.USER_ROW_ID = T.USER_ROW_ID

Line 480: update PAY_USER_ROWS_F_TL T

476: (select NULL
477: from PAY_USER_ROWS_F B
478: where B.USER_ROW_ID = T.USER_ROW_ID
479: );
480: update PAY_USER_ROWS_F_TL T
481: set (ROW_LOW_RANGE_OR_NAME) =
482: (select B.ROW_LOW_RANGE_OR_NAME
483: from PAY_USER_ROWS_F_TL B
484: where B.USER_ROW_ID = T.USER_ROW_ID

Line 483: from PAY_USER_ROWS_F_TL B

479: );
480: update PAY_USER_ROWS_F_TL T
481: set (ROW_LOW_RANGE_OR_NAME) =
482: (select B.ROW_LOW_RANGE_OR_NAME
483: from PAY_USER_ROWS_F_TL B
484: where B.USER_ROW_ID = T.USER_ROW_ID
485: and B.LANGUAGE = T.SOURCE_LANG)
486: where (T.USER_ROW_ID,T.LANGUAGE) in
487: (select SUBT.USER_ROW_ID,SUBT.LANGUAGE

Line 488: from PAY_USER_ROWS_F_TL SUBB, PAY_USER_ROWS_F_TL SUBT

484: where B.USER_ROW_ID = T.USER_ROW_ID
485: and B.LANGUAGE = T.SOURCE_LANG)
486: where (T.USER_ROW_ID,T.LANGUAGE) in
487: (select SUBT.USER_ROW_ID,SUBT.LANGUAGE
488: from PAY_USER_ROWS_F_TL SUBB, PAY_USER_ROWS_F_TL SUBT
489: where SUBB.USER_ROW_ID = SUBT.USER_ROW_ID
490: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
491: and (SUBB.ROW_LOW_RANGE_OR_NAME <> SUBT.ROW_LOW_RANGE_OR_NAME
492: ));

Line 493: insert into PAY_USER_ROWS_F_TL (

489: where SUBB.USER_ROW_ID = SUBT.USER_ROW_ID
490: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
491: and (SUBB.ROW_LOW_RANGE_OR_NAME <> SUBT.ROW_LOW_RANGE_OR_NAME
492: ));
493: insert into PAY_USER_ROWS_F_TL (
494: USER_ROW_ID,
495: ROW_LOW_RANGE_OR_NAME,
496: LAST_UPDATE_DATE,
497: LAST_UPDATED_BY,

Line 513: from PAY_USER_ROWS_F_TL B, FND_LANGUAGES L

509: B.CREATED_BY,
510: B.CREATION_DATE,
511: L.LANGUAGE_CODE,
512: B.SOURCE_LANG
513: from PAY_USER_ROWS_F_TL B, FND_LANGUAGES L
514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL

Line 518: from PAY_USER_ROWS_F_TL T

514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL
518: from PAY_USER_ROWS_F_TL T
519: where T.USER_ROW_ID = B.USER_ROW_ID
520: and T.LANGUAGE = L.LANGUAGE_CODE);
521: end ADD_LANGUAGE;
522: --

Line 530: UPDATE PAY_USER_ROWS_F_TL

526: X_ROW_LOW_RANGE_OR_NAME in VARCHAR2,
527: X_OWNER in VARCHAR2
528: ) is
529: begin
530: UPDATE PAY_USER_ROWS_F_TL
531: SET ROW_LOW_RANGE_OR_NAME = nvl(X_ROW_LOW_RANGE_OR_NAME,ROW_LOW_RANGE_OR_NAME),
532: last_update_date = SYSDATE,
533: last_updated_by = decode(x_owner,'SEED',1,0),
534: last_update_login = 0,

Line 585: pay_user_rows_f_tl urt

581: p_bus_grp_id IN NUMBER,
582: p_leg_code IN varchar2) IS
583: select '1'
584: from pay_user_rows_f pur,
585: pay_user_rows_f_tl urt
586: where upper(urt.row_low_range_or_name) = upper(p_row_low_range_or_name)
587: AND pur.user_row_id = urt.user_row_id
588: AND (urt.user_row_id <> p_user_row_id OR p_user_row_id IS NULL)
589: AND pur.user_table_id = p_user_table_id