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 1098: SELECT defined_balance_id FROM pay_defined_balances

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

Line 1175: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;

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