DBA Data[Home] [Help]

APPS.PAY_ZA_SOE dependencies on PAY_BALANCE_DIMENSIONS

Line 492: balance_suffix pay_balance_dimensions.dimension_name%TYPE;

488: name_count number;
489: dim_id number;
490: balance_name varchar2(80);
491: display_name varchar2(80);
492: balance_suffix pay_balance_dimensions.dimension_name%TYPE;
493: balance_val varchar2(80);
494: bal_found_flag varchar2(80);
495: l_date_earned varchar2(15);
496: l_run_assignment_action_id number;

Line 505: balance_suffix pay_balance_dimensions.dimension_name%TYPE

501: type balance_rec is record
502: (
503: balance_name varchar2(80),
504: display_name varchar2(80),
505: balance_suffix pay_balance_dimensions.dimension_name%TYPE
506: );
507: --
508: type user_balance_table_type is table of balance_rec index by binary_integer;
509: --

Line 519: ,pay_balance_dimensions pbd

515: Select pbt.balance_name as balance_name
516: ,nvl(org.org_information7,pbt.balance_name) as display_name
517: ,pbd.dimension_name as balance_suffix
518: From pay_balance_types pbt
519: ,pay_balance_dimensions pbd
520: ,pay_assignment_actions paa
521: ,pay_payroll_actions ppa
522: ,per_all_assignments_f asg
523: ,hr_organization_information org