DBA Data[Home] [Help]

APPS.PAY_AU_PAYSUM_ALLOWANCE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 24: p_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type,

20:
21: procedure upgrade_allowance_bar (
22: errbuf out NOCOPY varchar2,
23: retcode out NOCOPY varchar2,
24: p_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type,
25: p_mode in varchar2
26: ) is
27:
28: CURSOR get_dimension_asg_le_ytd IS

Line 80: CURSOR get_allowance_balance_lst (c_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type)

76: ;
77:
78:
79:
80: CURSOR get_allowance_balance_lst (c_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type)
81: IS
82: select pbt.balance_name, pbt.balance_type_id
83: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
84: ,pay_balance_attributes pba

Line 287: p_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type,

283:
284: procedure upgrade_ba (
285: p_cnt in number,
286: p_allowance_balance in tab_allowance_balance,
287: p_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type,
288: p_mode in varchar2
289: ) is
290:
291: CURSOR get_balance_attribute IS

Line 679: p_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type,

675:
676: procedure upgrade_AU_address_style (
677: errbuf out NOCOPY varchar2,
678: retcode out NOCOPY varchar2,
679: p_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type,
680: p_mode in varchar2
681: ) IS
682:
683: cursor csr_get_auglb_adress is