DBA Data[Home] [Help]

APPS.PAY_SE_WAGES_SALARIES dependencies on PAY_DEFINED_BALANCES

Line 551: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;

547: l_gross_salary number;
548: l_start_date date;
549: l_end_date date;
550: l_termination_date date;
551: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;
552: l_value number;
553: l_assignment_id pay_Assignment_actions.assignment_id%type;
554: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;
555: L_CFAR_NUMBER NUMBER;

Line 1099: SELECT defined_balance_id FROM pay_defined_balances

1095: AND hoi.org_information2=csr_v_display_name;--'CCD'
1096:
1097: cursor csr_get_defined_balance(csr_v_balance_type_id NUMBER, csr_v_balance_dimension_id NUMBER)
1098: is
1099: SELECT defined_balance_id FROM pay_defined_balances
1100: WHERE
1101: balance_type_id=csr_v_balance_type_id --10504412
1102: AND balance_dimension_id=csr_v_balance_dimension_id; --5525498
1103:

Line 1176: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;

1172: l_gross_salary number;
1173: --l_start_date date;
1174: --l_end_date date;
1175: l_termination_date date;
1176: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;
1177: l_value number;
1178: l_assignment_id pay_Assignment_actions.assignment_id%type;
1179: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;
1180: L_CFAR_NUMBER NUMBER;