APPS.PQP_HROSS_INTEGRATION dependencies on FND_DESCR_FLEX_CONTEXTS

Line 143: FROM fnd_descr_flex_contexts dfc

139:
140: -- Cursor to check the valid DF context
141: CURSOR csr_style (c_context_code IN Varchar2) IS
142: SELECT dfc.descriptive_flex_context_code
143: FROM fnd_descr_flex_contexts dfc
144: WHERE dfc.application_id = 800
145: AND dfc.descriptive_flexfield_name = 'Person Developer DF'
146: AND dfc.enabled_flag = 'Y';
147:

Line 5575: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;

5571: csr_get_unmasked_ni ref_cur_typ;
5572: csr_get_party_id ref_cur_typ;
5573:
5574: l_chk_per chk_party%ROWTYPE;
5575: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
5576: l_emp_api_out t_hrEmpApi;
5577: l_asg_crit_out t_AsgUpdCrit_Api;
5578: l_updper_api_out t_UpdEmp_Api;
5579: l_crt_emp_api_out t_CreateContact_Api;

Line 6950: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;

6946: ) AS
6947: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Create_OSS_Person';
6948: l_effective_date Date;
6949: l_chk_per chk_party%ROWTYPE;
6950: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
6951: l_emp_api_out t_hrEmpApi;
6952: l_updper_api_out t_UpdEmp_Api;
6953: l_HireToJobapi_out t_HrToJob_Api;
6954: l_crt_emp_api_out t_CreateContact_Api;