DBA Data[Home] [Help]

APPS.HR_PAY_RATE_GSP_SS dependencies on PER_PAY_TRANSACTIONS_S

Line 613: update per_pay_transactions set

609: open pay_txn;
610: fetch pay_txn into pay_txn_id;
611:
612: if pay_txn%found then
613: update per_pay_transactions set
614: PAY_BASIS_ID = l_pay_basis_id,
615: change_amount_n = p_ltt_salary_data(1).salary_change_amount,
616: change_percentage = p_ltt_salary_data(1).salary_change_percent,
617: PROPOSED_SALARY_N = p_ltt_salary_data(1).proposed_salary

Line 658: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,

654: STATUS,-- STATUS,
655: DML_OPERATION,-- DML_OPERATION,
656: object_version_number)
657: values(
658: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
659: p_transaction_id, -- TRANSACTION_ID,
660: p_transaction_step_id,-- TRANSACTION_STEP_ID,
661: p_item_type,-- ITEM_TYPE,
662: p_item_key,-- ITEM_KEY,

Line 715: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,

711: STATUS,-- STATUS,
712: DML_OPERATION,-- DML_OPERATION,
713: object_version_number)
714: values(
715: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
716: p_transaction_id, -- TRANSACTION_ID,
717: p_transaction_step_id,-- TRANSACTION_STEP_ID,
718: p_item_type,-- ITEM_TYPE,
719: p_item_key,-- ITEM_KEY,