APPS.PAY_US_PSD_XML dependencies on FF_DATABASE_ITEMS

Line 107: FROM ff_database_items DI,

103: ) RETURN NUMBER IS
104: -- Get the defined_balance_id for the specified balance DB item.
105: CURSOR csr_defined_balance IS
106: SELECT TO_NUMBER(UE.creator_id)
107: FROM ff_database_items DI,
108: ff_user_entities UE
109: WHERE DI.user_name = p_db_item_name
110: AND UE.user_entity_id = DI.user_entity_id
111: AND UE.creator_type = 'B'

Line 145: l_user_entity_id ff_database_items.user_entity_id%type;

141: */
142:
143: function get_user_entity_id (p_dbi_name in varchar2)
144: return number is
145: l_user_entity_id ff_database_items.user_entity_id%type;
146:
147: begin
148:
149: select user_entity_id

Line 151: from ff_database_items

147: begin
148:
149: select user_entity_id
150: into l_user_entity_id
151: from ff_database_items
152: where user_name = p_dbi_name;
153:
154: return l_user_entity_id;
155:

Line 1531: l_psd_user_entity_id ff_database_items.user_entity_id%type;

1527:
1528: /* Local variables to select only those employees those PSD Withheld <>0*/
1529:
1530: l_psd_def_bal_id pay_defined_balances.defined_balance_id%type;
1531: l_psd_user_entity_id ff_database_items.user_entity_id%type;
1532: l_psd_balance_value number(15,2):=0;
1533: l_aaid pay_assignment_actions.assignment_action_id%type;
1534: l_eff_date date;
1535: l_jurisdiction_code VARCHAR2(30);

Line 2123: l_user_entity_id ff_database_items.user_entity_id%type;

2119:
2120:
2121: psd_rules_rec c_get_psd_rules%ROWTYPE;
2122:
2123: l_user_entity_id ff_database_items.user_entity_id%type;
2124: l_jurisdiction_code varchar2(100);
2125: l_user_entity_id_tab pay_us_psd_xml.number_data_type_table;
2126: l_value_tab pay_us_psd_xml.char240_data_type_table;
2127: l_object_version_number number;

Line 2807: l_psd_user_entity_id ff_database_items.user_entity_id%type;

2803:
2804: /* Local variables to select only those employees those PSD Withheld <>0*/
2805:
2806: l_psd_def_bal_id pay_defined_balances.defined_balance_id%type;
2807: l_psd_user_entity_id ff_database_items.user_entity_id%type;
2808: l_psd_balance_value number(15,2):=0;
2809:
2810: /* Local variables to archive PSD balances*/
2811: lv_balance_name VARCHAR2(80);

Line 2820: l_user_entity_id ff_database_items.user_entity_id%type;

2816: ln_city_wk_def_bal_id pay_defined_balances.defined_balance_id%type;
2817: ln_psd_count NUMBER := 0;
2818: ln_bal_value NUMBER(15,2) := 0;
2819:
2820: l_user_entity_id ff_database_items.user_entity_id%type;
2821: l_jurisdiction VARCHAR2(30);
2822:
2823: l_user_entity_id_tab pay_us_psd_xml.number_data_type_table;
2824: -- l_user_entity_tab pay_us_psd_xml.char240_data_type_table;