eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_JP_ID_PKG dependencies on PAY_DEFINED_BALANCES

Line 1148: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_DEFINED_BALANCES%ROWTYPE

1144: p_balance_type_id IN NUMBER,
1145: p_balance_dimension_id IN NUMBER,
1146: p_business_group_id IN NUMBER DEFAULT NULL,
1147: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1148: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_DEFINED_BALANCES%ROWTYPE
1149: --------------------------------------------------------------------------------
1150: IS
1151: l_unique_column_tbl UniColTbl;
1152: l_csr RefCsr;

Line 1153: l_rec PAY_DEFINED_BALANCES%ROWTYPE;

1149: --------------------------------------------------------------------------------
1150: IS
1151: l_unique_column_tbl UniColTbl;
1152: l_csr RefCsr;
1153: l_rec PAY_DEFINED_BALANCES%ROWTYPE;
1154: BEGIN
1155: unique_tbl_constructor('BALANCE_TYPE_ID','N',to_char(p_balance_type_id),l_unique_column_tbl);
1156: unique_tbl_constructor('BALANCE_DIMENSION_ID','N',to_char(p_balance_dimension_id),l_unique_column_tbl);
1157: bus_leg_constructor(p_business_group_id,p_legislation_code,l_unique_column_tbl);

Line 1159: l_csr := csr('PAY_DEFINED_BALANCES',l_unique_column_tbl);

1155: unique_tbl_constructor('BALANCE_TYPE_ID','N',to_char(p_balance_type_id),l_unique_column_tbl);
1156: unique_tbl_constructor('BALANCE_DIMENSION_ID','N',to_char(p_balance_dimension_id),l_unique_column_tbl);
1157: bus_leg_constructor(p_business_group_id,p_legislation_code,l_unique_column_tbl);
1158:
1159: l_csr := csr('PAY_DEFINED_BALANCES',l_unique_column_tbl);
1160: fetch l_csr into l_rec;
1161: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1162: l_rec := NULL;
1163: end if;

Line 1185: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_DEFINED_BALANCES%ROWTYPE

1181: p_balance_name IN VARCHAR2,
1182: p_dimension_name IN VARCHAR2,
1183: p_business_group_id IN NUMBER DEFAULT NULL,
1184: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1185: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_DEFINED_BALANCES%ROWTYPE
1186: --------------------------------------------------------------------------------
1187: IS
1188: l_balance_type_id NUMBER;
1189: l_balance_dimension_id NUMBER;

Line 1656: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_DEFINED_BALANCES%ROWTYPE

1652: END;
1653: --------------------------------------------------------------------------------
1654: FUNCTION payment_defined_balance_rec(
1655: p_business_group_id IN NUMBER,
1656: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_DEFINED_BALANCES%ROWTYPE
1657: --------------------------------------------------------------------------------
1658: IS
1659: l_rec PAY_DEFINED_BALANCES%ROWTYPE;
1660: l_legislation_code VARCHAR2(2);

Line 1659: l_rec PAY_DEFINED_BALANCES%ROWTYPE;

1655: p_business_group_id IN NUMBER,
1656: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_DEFINED_BALANCES%ROWTYPE
1657: --------------------------------------------------------------------------------
1658: IS
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,

Line 1664: pay_defined_balances pdb,

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