APPS.HR_JP_ID_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 550: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_DIMENSIONS%ROWTYPE

546: FUNCTION balance_dimension_rec(
547: p_dimension_name IN VARCHAR2,
548: p_business_group_id IN NUMBER DEFAULT NULL,
549: p_legislation_code IN VARCHAR2 DEFAULT NULL,
550: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_DIMENSIONS%ROWTYPE
551: --------------------------------------------------------------------------------
552: IS
553: l_csr RefCsr;
554: l_rec PAY_BALANCE_DIMENSIONS%ROWTYPE;

Line 554: l_rec PAY_BALANCE_DIMENSIONS%ROWTYPE;

550: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_DIMENSIONS%ROWTYPE
551: --------------------------------------------------------------------------------
552: IS
553: l_csr RefCsr;
554: l_rec PAY_BALANCE_DIMENSIONS%ROWTYPE;
555: BEGIN
556: l_csr := csr_with_bus_leg('PAY_BALANCE_DIMENSIONS','DIMENSION_NAME','T',p_dimension_name,p_business_group_id,p_legislation_code);
557: fetch l_csr into l_rec;
558: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 556: l_csr := csr_with_bus_leg('PAY_BALANCE_DIMENSIONS','DIMENSION_NAME','T',p_dimension_name,p_business_group_id,p_legislation_code);

552: IS
553: l_csr RefCsr;
554: l_rec PAY_BALANCE_DIMENSIONS%ROWTYPE;
555: BEGIN
556: l_csr := csr_with_bus_leg('PAY_BALANCE_DIMENSIONS','DIMENSION_NAME','T',p_dimension_name,p_business_group_id,p_legislation_code);
557: fetch l_csr into l_rec;
558: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
559: l_rec := NULL;
560: end if;

Line 1663: from pay_balance_dimensions pbd,

1659: l_rec PAY_DEFINED_BALANCES%ROWTYPE;
1660: l_legislation_code VARCHAR2(2);
1661: CURSOR csr_payment_defined_balance_id IS
1662: select pdb.*
1663: from pay_balance_dimensions pbd,
1664: pay_defined_balances pdb,
1665: pay_balance_types pbt
1666: where pbt.assignment_remuneration_flag='Y'
1667: and nvl(pbt.business_group_id,p_business_group_id)=p_business_group_id