APPS.HR_JP_ID_PKG dependencies on PAY_BALANCE_TYPES

Line 520: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_TYPES%ROWTYPE

516: FUNCTION balance_type_rec(
517: p_balance_name IN VARCHAR2,
518: p_business_group_id IN NUMBER DEFAULT NULL,
519: p_legislation_code IN VARCHAR2 DEFAULT NULL,
520: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_TYPES%ROWTYPE
521: --------------------------------------------------------------------------------
522: IS
523: l_csr RefCsr;
524: l_rec PAY_BALANCE_TYPES%ROWTYPE;

Line 524: l_rec PAY_BALANCE_TYPES%ROWTYPE;

520: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_TYPES%ROWTYPE
521: --------------------------------------------------------------------------------
522: IS
523: l_csr RefCsr;
524: l_rec PAY_BALANCE_TYPES%ROWTYPE;
525: BEGIN
526: l_csr := csr_with_bus_leg('PAY_BALANCE_TYPES','BALANCE_NAME','T',p_balance_name,p_business_group_id,p_legislation_code);
527: fetch l_csr into l_rec;
528: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 526: l_csr := csr_with_bus_leg('PAY_BALANCE_TYPES','BALANCE_NAME','T',p_balance_name,p_business_group_id,p_legislation_code);

522: IS
523: l_csr RefCsr;
524: l_rec PAY_BALANCE_TYPES%ROWTYPE;
525: BEGIN
526: l_csr := csr_with_bus_leg('PAY_BALANCE_TYPES','BALANCE_NAME','T',p_balance_name,p_business_group_id,p_legislation_code);
527: fetch l_csr into l_rec;
528: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
529: l_rec := NULL;
530: end if;

Line 1665: pay_balance_types pbt

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
1668: and nvl(pbt.legislation_code,l_legislation_code)=l_legislation_code
1669: and pdb.balance_type_id=pbt.balance_type_id