DBA Data[Home] [Help]

APPS.PAY_AC_ACTION_ARCH dependencies on PAY_DEFINED_BALANCES

Line 416: ,PDB PAY_DEFINED_BALANCES_PK

412: ,cp_curr_eff_date in date
413: ,cp_start_eff_date in date
414: ) is
415: select /*+ ORDERED INDEX(PRB PAY_RUN_BALANCES_N1
416: ,PDB PAY_DEFINED_BALANCES_PK
417: ,PBT PAY_BALANCE_TYPES_PK,
418: ,PET PAY_ELEMENT_TYPES_F_PK
419: ,PEC PAY_ELEMENT_CLASSIFICATION_PK
420: ,PETL PAY_ELEMENT_TYPES_F_TL_PK)

Line 444: ,pay_defined_balances pdb

440: ,4,'0')))), '00-000-0000') jurisdiction_code,
441: pet.element_information10,
442: pet.element_information12
443: from pay_run_balances prb
444: ,pay_defined_balances pdb
445: ,pay_balance_types pbt
446: ,pay_element_types_f pet
447: ,pay_element_classifications pec
448: ,pay_element_types_f_tl petl