DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on FND_APPLICATION

Line 1072: fnd_application fa

1068: cursor c_get_balances (cp_action_context in varchar2) is
1069: select fdu.form_left_prompt, pbt.balance_type_id
1070: from fnd_descr_flex_col_usage_tl fdu,
1071: pay_balance_types pbt,
1072: fnd_application fa
1073: where fdu.descriptive_flexfield_name = 'Action Information DF'
1074: and fdu.language = 'US'
1075: and pbt.balance_name = fdu.form_left_prompt
1076: and pbt.legislation_code = 'US'

Line 1088: fnd_application fa

1084: cursor c_get_psd_balances (cp_action_context in varchar2) is
1085: select fdu.form_left_prompt, pbt.balance_type_id
1086: from fnd_descr_flex_col_usage_tl fdu,
1087: pay_balance_types pbt,
1088: fnd_application fa
1089: where fdu.descriptive_flexfield_name = 'Action Information DF'
1090: and fdu.language = 'US'
1091: and pbt.balance_name = substr(fdu.form_left_prompt,
1092: 1 , decode(instr(fdu.form_left_prompt, 'YTD'),