APPS.PAY_SG_IRAS_ARCHIVE dependencies on PAY_BALANCE_VALIDATION

Line 1863: c_run_balance_status pay_balance_validation.run_balance_status%type ;

1859: p_date_to out nocopy ff_archive_items.value%type,
1860: p_no_of_times out nocopy number )
1861: is
1862: c_def_balance_id pay_defined_balances.defined_balance_id%type;
1863: c_run_balance_status pay_balance_validation.run_balance_status%type ;
1864:
1865: --
1866: cursor balance_dates_rr
1867: is

Line 1954: from pay_balance_validation

1950: cursor get_balance_status(c_def_balance_id pay_defined_balances.defined_balance_id%type,
1951: c_business_group_id hr_organization_units.business_group_id%type )
1952: is
1953: select run_balance_status
1954: from pay_balance_validation
1955: where defined_balance_id = c_def_balance_id
1956: and business_group_id = c_business_group_id;
1957: --
1958: begin