APPS.PQH_CPD_HR_TO_STAGE dependencies on PQH_CORPS_DEFINITIONS

Line 140: from ben_copy_entity_results cer, pqh_corps_definitions cpd

136: l_pgm_id number;
137: begin
138: select cer.information1,cer.copy_entity_txn_id,cpd.corps_definition_id
139: into l_pgm_id,p_cet_id,p_corps_id
140: from ben_copy_entity_results cer, pqh_corps_definitions cpd
141: where copy_entity_result_id = p_pgm_cer_id
142: and cpd.ben_pgm_id = cer.information1;
143: exception
144: when no_data_found then

Line 504: from pqh_corps_definitions

500: p_effective_date in date,
501: p_pgm_cer_id in number) is
502: cursor csr_cpd_rec is
503: select *
504: from pqh_corps_definitions
505: where ben_pgm_id = p_pgm_id;
506: l_cpd_tr_id number;
507: l_cpd_tr_name varchar2(80);
508: l_cpd_cer_id number;

Line 1185: pqh_corps_definitions_api.create_corps_definition

1181: AND l_pgm_id IS NOT NULL
1182: AND l_pgm_esd IS NOT NULL
1183: AND l_pgm_name IS NOT NULL
1184: THEN
1185: pqh_corps_definitions_api.create_corps_definition
1186: (p_effective_date => p_effective_date,
1187: p_date_from => l_pgm_esd,
1188: p_date_to => cpd_rec.information3,
1189: p_business_group_id => p_business_group_id,

Line 1229: (p_table_name => 'PQH_CORPS_DEFINITIONS',

1225: THEN
1226: hr_utility.set_location (' dt mode is ' || p_datetrack_mode, 30);
1227: l_db_ovn :=
1228: pqh_gsp_stage_to_ben.get_ovn
1229: (p_table_name => 'PQH_CORPS_DEFINITIONS',
1230: p_key_column_name => 'CORPS_DEFINITION_ID',
1231: p_key_column_value => l_cpd_id
1232: );
1233: hr_utility.set_location (' ovn is ' || l_db_ovn, 30);

Line 1244: pqh_corps_definitions_api.update_corps_definition

1240: fnd_message.set_token ('OBJECT ', l_object);
1241: fnd_message.set_token ('OBJECT_NAME ', cpd_rec.information5);
1242: fnd_message.raise_error;
1243: ELSE
1244: pqh_corps_definitions_api.update_corps_definition
1245: (p_effective_date => p_effective_date,
1246: p_date_from => l_pgm_esd,
1247: p_date_to => cpd_rec.information3,
1248: p_business_group_id => p_business_group_id,

Line 1335: pqh_corps_definitions_api.update_corps_definition

1331: WHERE copy_entity_txn_id = p_copy_entity_txn_id
1332: AND table_alias = 'CPD'
1333: AND dml_operation = 'REUSE';
1334:
1335: pqh_corps_definitions_api.update_corps_definition
1336: (p_effective_date => p_effective_date,
1337: p_corps_definition_id => l_corps_def_id,
1338: p_status_cd => l_status_cd,
1339: p_object_version_number => l_cpd_ovn