DBA Data[Home] [Help]

APPS.HR_PAY_RATE_GSP_SS dependencies on PER_PAY_TRANSACTIONS_S

Line 609: update per_pay_transactions set

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

Line 654: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,

650: STATUS,-- STATUS,
651: DML_OPERATION,-- DML_OPERATION,
652: object_version_number)
653: values(
654: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
655: p_transaction_id, -- TRANSACTION_ID,
656: p_transaction_step_id,-- TRANSACTION_STEP_ID,
657: p_item_type,-- ITEM_TYPE,
658: p_item_key,-- ITEM_KEY,

Line 711: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,

707: STATUS,-- STATUS,
708: DML_OPERATION,-- DML_OPERATION,
709: object_version_number)
710: values(
711: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
712: p_transaction_id, -- TRANSACTION_ID,
713: p_transaction_step_id,-- TRANSACTION_STEP_ID,
714: p_item_type,-- ITEM_TYPE,
715: p_item_key,-- ITEM_KEY,