APPS.PQH_GSP_HR_TO_STAGE dependencies on PQH_COPY_ENTITY_TXNS

Line 4341: from pqh_copy_entity_txns txn, ben_copy_entity_results cer

4337: p_user_id in number,
4338: p_business_area in varchar2 default 'PQH_GSP_TASK_LIST',
4339: p_copy_entity_txn_id out nocopy number ) is
4340: cursor csr_txns is select txn.copy_entity_txn_id
4341: from pqh_copy_entity_txns txn, ben_copy_entity_results cer
4342: where txn.context_business_group_id = p_business_group_id
4343: and txn.status ='VIEW'
4344: and txn.context ='GSP'
4345: and cer.copy_entity_txn_id = txn.copy_entity_txn_id

Line 4412: from pqh_copy_entity_txns txn, ben_copy_entity_results cer,

4408: p_user_id in number,
4409: p_business_area in varchar2 default 'PQH_GSP_TASK_LIST',
4410: p_copy_entity_txn_id out nocopy number ) is
4411: cursor csr_txns is select txn.copy_entity_txn_id
4412: from pqh_copy_entity_txns txn, ben_copy_entity_results cer,
4413: pqh_copy_entity_attribs attr
4414: where txn.context_business_group_id = p_business_group_id
4415: and attr.copy_entity_txn_id = txn.copy_entity_txn_id
4416: --changes for bug no 6030246 starts here

Line 4428: l_txn_name pqh_copy_entity_txns.display_name%type;

4424: and cer.table_alias = 'PGM';
4425:
4426: l_rec_found boolean := FALSE;
4427: l_user_name fnd_user.user_name%type;
4428: l_txn_name pqh_copy_entity_txns.display_name%type;
4429: l_cet_ovn number;
4430: l_copy_entity_txn_id number;
4431: begin
4432: -- when Grade ladder is selected for Update following things are to be done

Line 4517: pqh_copy_entity_txns_api.create_COPY_ENTITY_TXN

4513: and business_group_id is null;
4514: end if;
4515: if l_gsp_txn_cat is not null then
4516: begin
4517: pqh_copy_entity_txns_api.create_COPY_ENTITY_TXN
4518: (p_copy_entity_txn_id => p_copy_entity_txn_id
4519: ,p_transaction_category_id => l_gsp_txn_cat
4520: ,p_context_business_group_id => p_business_group_id
4521: ,p_context => 'GSP'