APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_BALANCE_TYPES

Line 133: FROM pay_balance_types pbt

129: CURSOR csr_defined_bal (c_balance_name IN Varchar2
130: ,c_dimension_name IN Varchar2
131: ,c_business_group_id IN Number) IS
132: SELECT db.defined_balance_id
133: FROM pay_balance_types pbt
134: ,pay_defined_balances db
135: ,pay_balance_dimensions bd
136: WHERE pbt.balance_name = c_balance_name
137: AND pbt.balance_type_id = db.balance_type_id

Line 298: FROM pay_balance_types pbt

294: CURSOR csr_bal_typid (c_balance_name IN Varchar2
295: ,c_business_group_id IN Number
296: ,c_legislation_code IN Varchar2) IS
297: SELECT pbt.balance_type_id
298: FROM pay_balance_types pbt
299: WHERE pbt.balance_name = c_balance_name
300: AND (pbt.business_group_id = c_business_group_id
301: OR
302: pbt.legislation_code = c_legislation_code);

Line 2107: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

2103: l_bal_total_amt NUMBER :=0;
2104: l_dimension_name VARCHAR2(100);
2105: i per_all_assignments_f.business_group_id%TYPE;
2106: l_legislation_code per_business_groups.legislation_code%TYPE;
2107: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
2108: l_index NUMBER;
2109:
2110: BEGIN
2111:

Line 7276: ,p_balance_name IN pay_balance_types.balance_name%TYPE

7272: FUNCTION Get_Pension_Salary
7273: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7274: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
7275: ,p_effective_date IN DATE
7276: ,p_balance_name IN pay_balance_types.balance_name%TYPE
7277: ,p_asg_act IN NUMBER
7278: ,p_error_message OUT NOCOPY VARCHAR2
7279: ,p_data_element_value OUT NOCOPY VARCHAR2)
7280: RETURN NUMBER IS

Line 7299: l_balance_id pay_balance_types.balance_type_id%TYPE;

7295:
7296: l_ret_val NUMBER := 0;
7297: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
7298: l_bal_exists NUMBER;
7299: l_balance_id pay_balance_types.balance_type_id%TYPE;
7300: l_balance_amount NUMBER := 0;
7301: l_override_value ben_ext_chg_evt_log.new_val1%TYPE;
7302: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Pension_Salary';
7303: l_eff_dt DATE;

Line 8590: l_balance_id pay_balance_types.balance_type_id%TYPE;

8586: l_balance_amount NUMBER := 0;
8587: l_override_value NUMBER := 0;
8588: l_person_id per_all_people_f.person_id%TYPE;
8589: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
8590: l_balance_id pay_balance_types.balance_type_id%TYPE;
8591: l_proc_name VARCHAR2(150) := g_proc_name ||'Record08_Display_Criteria';
8592: l_hire_dt DATE;
8593: l_08_sent NUMBER;
8594: l_ret_val_asg NUMBER;